Home » Developer & Programmer » Forms » FRM-40564:RECORD HAS BEEN UPDATED BY ANOTHER USER-REQUERY TO SEE CHANGE
FRM-40564:RECORD HAS BEEN UPDATED BY ANOTHER USER-REQUERY TO SEE CHANGE [message #224736] Thu, 15 March 2007 05:04 Go to next message
zshanalig1
Messages: 4
Registered: March 2007
Location: pakistan
Junior Member
AS SALAM O ALAIKUM!

I HAVE A FORM WITH MASTER AND DETAIL BLOCKS,

IN MASTER BLOCK I HAVE A FIELD CALLED INV_BAL
WHEN I UPDATE QTY/RATE/AMOUNT/GST% FIELDS IN DETAIL BLOCK'S FIELDS THEN I HAVE TO UPDATE INV_BAL FIELD IN MASTER BLOCK BUT WHEN I UPDATE QTY/RATE/AMOUNT/GST% IN DETAIL BLOCK AND AFTER THAT WHEN I WANT TO UPDATE SOMETHING IN MASTER BLOCK IT GIVES ME THE FOLLOWING ERROR

FRM-40564:RECORD HAS BEEN UPDATED BY ANOTHER USER-REQUERY TO SEE CHANGE

NOTE:I UPDATE INV_BAL FIELD ON POST UPDATE OF DETAIL BLOCK AND NO ONE IS USING THIS FORM / RECORD AT THIS TIME COZ I M WORKING ON A SINGLE PC

[Updated on: Thu, 15 March 2007 05:12]

Report message to a moderator

Re: FRM-40564:RECORD HAS BEEN UPDATED BY ANOTHER USER-REQUERY TO SEE CHANGE [message #225461 is a reply to message #224736] Tue, 20 March 2007 00:34 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please do not use all capitals in your postings. It is hard to read and is considering insulting ('shouting') by many users.

Because you used the POST-Change trigger the record in the database is considered to have been updated AFTER the commit. Therefore it is being 'updated by another user'. Put the new information into 'INV_BAL' in the 'Pre-Update' trigger.

David
Re: FRM-40564:RECORD HAS BEEN UPDATED BY ANOTHER USER-REQUERY TO SEE CHANGE [message #387363 is a reply to message #225461] Thu, 19 February 2009 00:21 Go to previous messageGo to next message
kumar_apps
Messages: 51
Registered: November 2006
Location: hyderabad
Member
Hi,

The problem I am facing is a bit different but follows the same error code hence I am posting here.
The error I faced is "FRM-4054:Record has been updated. Requery block to see change.".
This error is poppedup when I attempt to change Supplier/Supplier Site information of a particular supplier and also when attempting to change Distributions of a few inovices.

Kindly help me provide clues to resolve this.

Regards,
Kumar
Re: FRM-40564:RECORD HAS BEEN UPDATED BY ANOTHER USER-REQUERY TO SEE CHANGE [message #387364 is a reply to message #387363] Thu, 19 February 2009 00:38 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Is this a new error or one that has been occurring for a long time. If the prior, what have you changed lately?

Is this a master/detail form? Do you have any custom code associated with the two blocks? You will need to find the status of he blocks and determine why one of them is changing. You have code in your form and unfortunately you will have to read it all and then determine which part is causing the problem.

Which version of Forms are you using? Use the debug facility to work through the code. Use 'message; pause;' pairs to display information at the significant function points.

David
Previous Topic: Problem with Exec_sql for an insert stmt
Next Topic: can't used the order by clause in Cursor?
Goto Forum:
  


Current Time: Mon Feb 03 20:35:07 CST 2025