Received: from email03.aon.at (WARSL401PIP5.highway.telekom.at [195.3.96.112]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5LBCoa08817 for ; Thu, 21 Jun 2001 07:12:51 -0400 (EDT) (envelope-from i.hasenoehrl@aon.at) Received: (qmail 346376 invoked from network); 21 Jun 2001 11:12:47 -0000 Received: from n654p020.adsl.highway.telekom.at (HELO irina) ([62.47.25.180]) (envelope-sender ) by qmail3.highway.telekom.at (qmail-ldap-1.03) with SMTP for ; 21 Jun 2001 11:12:47 -0000 Message-ID: <007601c0fa43$28bb72e0$01011eac@irina> From: =?iso-8859-1?Q?DI_Hasen=F6hrl?= To: Subject: Problem by inserting rows in a table via function Date: Thu, 21 Jun 2001 13:13:11 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0073_01C0FA53.EBF7F7A0" 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/327 X-Sequence-Number: 3614 This is a multi-part message in MIME format. ------=_NextPart_000_0073_01C0FA53.EBF7F7A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all, I use postgresql 7.0.2 as backend, ODBC Driver 7.1.003 and MsAccess97 as fr= ontend. Now I have the following Problem and hope, someone can help me. I developed a function in plpgsql, which inserts rows in a table *price*. T= his function is called from VBA-Code and everything seemed to be OK, but th= en I realized, that I can't change these rows inserted by the function. Whe= n I put in rows by the normal way as linked table, I can change these rows.= Where is the difference to insert rows by a function or per hand. Has anyone an idea, please let me know. Thanks in advance Irina =20 E-Mail: i.hasenoehrl@aon.at ------=_NextPart_000_0073_01C0FA53.EBF7F7A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello all,
 
I use postgresql 7.0.2 as backend, ODBC Dr= iver=20 7.1.003 and MsAccess97 as frontend.
Now I have the following Problem and hope,= someone=20 can help me.
 
I developed a function in plpgsql, which i= nserts=20 rows in a table *price*. This function is called from VBA-Code and everythi= ng=20 seemed to be OK, but then I realized, that I can't change these rows insert= ed by=20 the function. When I put in rows by the normal way as linked table, I can c= hange=20 these rows. Where is the difference to insert rows by a function or per=20 hand.
 
Has anyone an idea, please let me=20 know.
 
Thanks in advance
Irina
 
E-Mail: i.hasenoehrl@aon.at
------=_NextPart_000_0073_01C0FA53.EBF7F7A0--