The messge is usually associated with mutli-user enviroments and usually
means two users have retrieved and modified the same row (sometimes refred
to as "contention"). The user that got the message needs to re-retireve the
row, re-modifiy it and re-save it.
That being said, I have seen the message somewhat frequently in the past,
and it was never casued by contention, my mind is a little un-clear re: how
we fixed it, but I think one cause is table columns with default values. A
table is defined with defualt values such that when a row in inserted, if
the columnd vaue is NULL, it will be replace with a valid value (such as
zero). The solution is to set up the datawindow so that it supplies the
same default value for the column as the table definition.
I've written this a little quickly, if there is anything you don't
understand, let me know.
HTH,
Lester LaForce
[EMAIL PROTECTED]
Contractor, Future Technologies, Inc.
Armed Forces Institute of Pathology
Washington DC
-----Original Message-----
From: Sawant Prasad [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 29, 2000 5:19 AM
To: [EMAIL PROTECTED]
Subject: PFCSIG Datawindow Error while updating
Can u please help me.
When i am updating a datawindow i get the following error.
Datawindow Error
Row changed between retrieve and update.
Can anyone provide me the solution at the earliest.
This error is not regular. It comes rarely.
Thanking you in advance
Prasad Sawant
email - [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]
