Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Infomaker "table changed between update and retrieve" msg -- No update, No how

2 posts in PB Infomaker Report Writer Last posting was on 1997-11-17 18:42:17.0Z
Mark & Pat Damia Posted on 1997-11-15 20:15:55.0Z
Newsgroups: sybase.public.infomaker.general
From: "Mark & Pat Damia" <MarkandPatDamia@compuserve.com>
Subject: Infomaker "table changed between update and retrieve" msg -- No update, No how
X-Newsreader: Microsoft Internet News 4.70.1162
Date: Sat, 15 Nov 1997 15:15:55 -0500
Lines: 9
Message-ID: <348_01bcf20c$062d6960$50f3aec7@default>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7389
Article PK: 244445

Hello Everyone,

I just put together a very simple form and this should have been easy.
However, when I try to run it and update the table I get a mesage that says
"Row changed since retrieve and update" What the heck is going on? I
checked the update properties and they look OK.

Any help would be appreciated

Thanks in advance


Terry Dykstra Posted on 1997-11-17 18:42:17.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Infomaker "table changed between update and retrieve" msg -- No update, No how
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Mon, 17 Nov 1997 13:42:17 -0500
Lines: 20
Message-ID: <348_01bcf390$f4322b20$8366e4cf@tdykstra.cfol.ab.ca>
References: <348_01bcf20c$062d6960$50f3aec7@default>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7386
Article PK: 244443

This is a problem that a lot of people struggle with. A few sugestions:

- Under the Update properties for the form, under the Where Clause for
update/delete, choose 'Key columns' or 'Key and Modified Columns'.
- Change the key modification to use 'update', not 'delete then insert'.

Terry Dykstra (TeamPS)

Mark & Pat Damia <MarkandPatDamia@compuserve.com> wrote in article
<01bcf20c$062d6960$50f3aec7@default>...
> Hello Everyone,
>
> I just put together a very simple form and this should have been easy.
> However, when I try to run it and update the table I get a mesage that
says
> "Row changed since retrieve and update" What the heck is going on? I
> checked the update properties and they look OK.
>
> Any help would be appreciated