Ah yes, the dreaded error. RCBR&U.
A couple of things could be causing this:
(a) Another user actually changed the underlying row.
(b) You changed the underlying row in a different process ( another
window, a trigger, etc.)
(c) You changed the status flags somehow.
In my experience, option (a) is actually the least likely and I jump right
to (c).
The best way to figure out what is going on is to do this:
Before the update, create a loop that will go through all the columns of the
row that is given you troubles and have it display the itemStatus. I've
even created a function that takes the dwStatus enumerated type as an
argument and opens a message box with the english equivalant.
After viewing all the status', find which one is not as you expect and then
work back through your code to figure out where it is being changed.
Good luck....
D
----- Original Message -----
From: FRAIKIN Francis <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 04, 2000 10:33 AM
Subject: PFCSIG Save Problem
> After deleting a row it's impossible to save and I receive an error
message.
>
> Row changed between retrieve and update
> No changes made to the database
>
> Delete from "TS_INITIALES" Where "ID_AGENT" = 3090
>
> I'm using 2 dw (with sharedata) on 1 window the Save after Insert action
is
> OK.
>
> Update properties of the 2 dw : Allow Updates ON
> Key Columns ON
> Use Update ON
>
> What's wrong?
>
> Francis
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
