Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5MCiqa51850 for ; Fri, 22 Jun 2001 08:44:52 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from host0.xcom.fr (host0.xcom.fr [213.215.14.219]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5M86ba36248 for ; Fri, 22 Jun 2001 04:06:38 -0400 (EDT) (envelope-from cslucki@cyberworkers.com) Received: (qmail 23828 invoked from network); 22 Jun 2001 04:51:26 -0000 Received: from proxy.xcom.fr (HELO pccyril) (213.215.14.233) by host0.xcom.fr with SMTP; 22 Jun 2001 04:51:26 -0000 Reply-To: From: "Cyril Slucki" To: Subject: RE: Difference between insert a tuple in a table by function and by datasheet Date: Fri, 22 Jun 2001 10:02:36 +0200 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0045_01C0FB02.768555D0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 In-Reply-To: <001e01c0faec$352f6be0$01011eac@irina> Importance: Normal X-Archive-Number: 200106/363 X-Sequence-Number: 3650 C'est un message de format MIME en plusieurs parties. ------=_NextPart_000_0045_01C0FB02.768555D0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit REMOVE -----Message d'origine----- De : pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]De la part de DI Hasenöhrl Envoyé : vendredi 22 juin 2001 09:23 À : pgsql-sql@postgresql.org; pgsql-odbc@postgresql.org Objet : [SQL] Difference between insert a tuple in a table by function and by datasheet Hi, this is my 2nd attempt to get some links for my problem. I don't know whether my question is so stupid or difficult or I'm in the wrong list. Please let me know. I have the following situation: ( I use MsAccess97 as frontend, ODBC 7.1.0003) I insert tuples in a table with a plpgsql-function, called in a form via VBA-code. It works fine, but I can't update these tuples in datasheet view. ERROR: an other user has changed in the meantime.....but I'm the only. When I insert tuples via datasheet view, I can update these tuples, but only these. I can't see a difference between the tuples inserted by the function and datasheet, but it looks like, that the tuples are *marked*. Please, give me some information to solve my problem. Thanks Irina E-Mail: i.hasenoehrl@aon.at ---------------------------------------------------------------------------- -- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (www.grisoft.com). Version: 6.0.262 / Virus Database: 132 - Release Date: 12/06/2001 ------=_NextPart_000_0045_01C0FB02.768555D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
REMOVE
-----Message d'origine-----
De :=20 pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]= De la=20 part de DI Hasen=F6hrl
Envoy=E9 : vendredi 22 juin 200= 1=20 09:23
=C0 : pgsql-sql@postgresql.org;=20 pgsql-odbc@postgresql.org
Objet : [SQL] Difference between= =20 insert a tuple in a table by function and by datasheet

Hi,
 
this is my 2nd attempt to get some links= for my=20 problem.
I don't know whether my question is so s= tupid or=20 difficult or I'm in the wrong list. Please let me know.
 
I have the following situation: ( I use= =20 MsAccess97 as frontend, ODBC 7.1.0003)
I insert tuples in a table with a=20 plpgsql-function, called in a form via VBA-code. It works fine, but I can= 't=20 update these tuples in datasheet view. ERROR: an other user has changed i= n the=20 meantime.....but I'm the only.
When I insert tuples via datasheet view,= I can=20 update these tuples, but only these.
 
I can't see a difference between the tup= les=20 inserted by the function and datasheet, but it looks like, that the tuple= s are=20 *marked*.
 
Please, give me some information to solv= e my=20 problem.
 
Thanks
Irina
 
E-Mail: i.hasenoehrl@aon.at


Incoming mail is certified Virus Free.
Che= cked by=20 AVG anti-virus system (www.grisoft.com= ).=20
Version: 6.0.262 / Virus Database: 132 - Release Date:=20 12/06/2001


Outgoing mail is certified Virus Free.=
Checked by AVG anti-virus system (www.gr= isoft.com).
Version: 6.0.262 / Virus Database: 132 - Release Date: 12/06/2001

------=_NextPart_000_0045_01C0FB02.768555D0--