problem while saving [message #395102] |
Tue, 31 March 2009 05:27 |
sivajyothi.kalikiri
Messages: 29 Registered: March 2009
|
Junior Member |
|
|
while i am saving, i am getting a message like
'RECORD HAS BEEN UPDATED BY ANOTHER USER. RE-QUERY TO SEE THE CHANGES'
But my data is saving successfully.
I should not get this message while i am saving.
why it is coming like this?
Actially i am updating this data from another form, Is it this reason why i am getting this message?
|
|
|
|
|
Re: problem while saving [message #395293 is a reply to message #395259] |
Wed, 01 April 2009 01:43 |
sivajyothi.kalikiri
Messages: 29 Registered: March 2009
|
Junior Member |
|
|
I got the solution for this problem,
what i thought is correct.as i am updating the data from another form ,the message is coming.
In order to overcome that we have to set block property
'dml returning value' as yes.
|
|
|
Re: problem while saving [message #395349 is a reply to message #395102] |
Wed, 01 April 2009 03:36 |
cookiemonster
Messages: 13963 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
If it's really another form that's changing the record then I'd be very surprised if setting DML returning values would fix it.
DML returning values is for picking up any changes made to your record by database triggers.
If the record has been changed by another form then you should, as it suggests, requery the record.
|
|
|