OraFAQ Forum: Forms » Record has been updated by another user. Re-query to see change

Home » Developer & Programmer » Forms » Record has been updated by another user. Re-query to see change (10g,XE Database,windows7(32))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Record has been updated by another user. Re-query to see change [message #637819]

Tue, 26 May 2015 07:32

tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh

Junior Member

hi,

in my form every thing is working good..
when i update or delete some thing then press save button the display item show me how many row is updated.

but when i insert new record then press save button this error displayed "Record has been updated by another user. Re-query to see change" ..

please help me how to solve it ?

Regards

Attachment: UPDATE_COUNT(3)(1).fmb
(Size: 68.00KB, Downloaded 1531 times)

Report message to a moderator

Re: Record has been updated by another user. Re-query to see change [message #637820 is a reply to message #637819]

Tue, 26 May 2015 07:43

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Requery?

Report message to a moderator

Re: Record has been updated by another user. Re-query to see change [message #637821 is a reply to message #637820]

Tue, 26 May 2015 07:52

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have you got a post-insert trigger that modifies the contents of the data block?

Report message to a moderator

Re: Record has been updated by another user. Re-query to see change [message #637822 is a reply to message #637821]

Tue, 26 May 2015 08:11

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

Or an actual database trigger on the table that modifies it (before insert row)?

Report message to a moderator

Re: Record has been updated by another user. Re-query to see change [message #637829 is a reply to message #637822]

Tue, 26 May 2015 22:52

tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh

Junior Member

hi cookiemonster ,

thanks. Mr. could u please help me by editing .fmb file ?

Regards

Report message to a moderator

Re: Record has been updated by another user. Re-query to see change [message #637830 is a reply to message #637829]

Tue, 26 May 2015 23:00

tofajjalhnipu66@gmail.com
Messages: 18
Registered: May 2015
Location: Chittagong,Bangladesh

Junior Member

Hi Mr.Michel Cadot ,

What do u mean by this? (Re-query?)

Report message to a moderator

Re: Record has been updated by another user. Re-query to see change [message #637837 is a reply to message #637830]

Wed, 27 May 2015 00:04

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Exactly what Forms told you to do, I suppose:

"Record has been updated by another user. Re-query to see change"

Report message to a moderator

Re: Record has been updated by another user. Re-query to see change [message #637839 is a reply to message #637837]

Wed, 27 May 2015 01:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Although Michel's suggestion is perfectly OK, I know that he doesn't use Forms so - requerying won't help much.

Just in case you didn't understand what Cookiemonster is saying, let me try to rephrase it: did you write some INSERT INTO ... or UPDATE ... statements by yourself? If you did, well, you most probably shouldn't have. Forms does that for you. If you created a form using Data block wizard, your form will be able to insert new records, query existing ones as well as update them - you don't have to write a single line of code.

Therefore, review the form and remove (comment) all INSERT and/or UPDATE statements you wrote. Then run the form again and see what happens.

Report message to a moderator

Re: Record has been updated by another user. Re-query to see change [message #637840 is a reply to message #637839]

Wed, 27 May 2015 02:47

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

I can't modify the fmb - I haven't got a working forms installation.
From memory the normal causes of this error are:
1) A DB trigger modifies the data as it's being inserted/updated - a before insert/update row trigger - setting block property DML Return to Yes will fix this.
2) Having a post-insert or post-update trigger that modifies the contents of the datablocks.
3) Having some code anywhere that does a direct update on the database rows that are in the datablocks.

To fix 2 and 3 you need to redesign the form so that you're not doing the action that causes the error.

Report message to a moderator

Previous Topic:	How to get record number and total record number in record indicator?
Next Topic:	Master Detail Relation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 07:56:20 CST 2025