Received: from email02.aon.at (WARSL401PIP3.highway.telekom.at [195.3.96.75]) by postgresql.org (8.11.3/8.11.1) with SMTP id f56HrQE53914 for ; Wed, 6 Jun 2001 13:53:26 -0400 (EDT) (envelope-from i.hasenoehrl@aon.at) Received: (qmail 477430 invoked from network); 6 Jun 2001 17:53:24 -0000 Received: from n681p003.adsl.highway.telekom.at (HELO irina) ([62.47.29.3]) (envelope-sender ) by qmail2.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 6 Jun 2001 17:53:24 -0000 Message-ID: <00c701c0eeb1$a9e2a980$01011eac@irina> From: =?iso-8859-1?Q?DI_Hasen=F6hrl?= To: Subject: How to create a *pass-through-query* in postgresql Date: Wed, 6 Jun 2001 19:53:58 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00C4_01C0EEC2.6D1F2E40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200106/75 X-Sequence-Number: 3294 This is a multi-part message in MIME format. ------=_NextPart_000_00C4_01C0EEC2.6D1F2E40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all, I use postgresql as backend and MsAccess97 as frontend via ODBC. I know, how to use VBA and pass through queries to update or insert rows in= postgresql-tables. But I don't know, how to do this the other way round, from postgresql to Ms= Access. I want to develop a trigger, which updates or inserts rows in some local ta= bles in MsAccess on the client side. =20 How can I realize a *pass through query* in postgresql ( with plpgsql ?) to= be executed in MsAccess? Is there a possibility, to send updates or inserts from postgresql-tables t= o local MsAccess-tables (without linked tables) I have the following situation: 1 postgresql database and some clients on different locations, connected = via internet I want to hold some information realy local (no linked table) to the clie= nts and to the host, because the connection is not very fast when client_1 changes a special table in the postgresql DB, this should b= e transmitted to a local MsAccess-table to client_2=20 Can I solve this problem with plpgsql???????????? Please, can anyone help me to solve this problem. Thanks in advance Irina =20 E-Mail: i.hasenoehrl@aon.at ------=_NextPart_000_00C4_01C0EEC2.6D1F2E40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello all,
 
I use postgresql as backend and MsAccess97= as=20 frontend via ODBC.
I know, how to use VBA and pass through qu= eries to=20 update or insert rows in postgresql-tables.
But I don't know, how to do this the other= way=20 round, from postgresql to MsAccess.
I want to develop a trigger, which updates= or=20 inserts rows in some local tables in MsAccess on the client=20 side.
 
How can I realize a *pass through query* i= n=20 postgresql ( with plpgsql ?) to be executed in MsAccess?
 
Is there a possibility, to send updates or= inserts=20 from postgresql-tables to local MsAccess-tables (without linked=20 tables)
 
I have the following situation:
1 postgresql database and some= clients=20 on different locations, connected via internet
I want to hold some information realy lo= cal (no=20 linked table) to the clients and to the host, because the connection is n= ot=20 very fast
when client_1 changes a special table in= the=20 postgresql DB, this should be transmitted to a local MsAccess-table to=20 client_2
Can I solve this problem with=20 plpgsql????????????
 
Please, can anyone help me to solve this= =20 problem.
 
Thanks in advance
Irina
 
E-Mail: i.hasenoehrl@aon.at
------=_NextPart_000_00C4_01C0EEC2.6D1F2E40--