Home » Developer & Programmer » Forms » problem while saving (forms 6i)
problem while saving [message #395102] Tue, 31 March 2009 05:27 Go to next message
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 #395131 is a reply to message #395102] Tue, 31 March 2009 07:31 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
Almost certainly
Re: problem while saving [message #395259 is a reply to message #395131] Tue, 31 March 2009 23:24 Go to previous messageGo to next message
sivajyothi.kalikiri
Messages: 29
Registered: March 2009
Junior Member
what I have to do for not getting the above message while saving.
Re: problem while saving [message #395293 is a reply to message #395259] Wed, 01 April 2009 01:43 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: detail block not displaying values when master block is executed
Next Topic: Radiobutton value doesn't change when query
Goto Forum:
  


Current Time: Mon Feb 03 20:53:29 CST 2025