Home » Developer & Programmer » Forms » FRM-40657 Record changed or deleted by another user
FRM-40657 Record changed or deleted by another user [message #375344] Fri, 01 September 2000 12:03 Go to next message
Monte Roe
Messages: 2
Registered: September 2000
Junior Member
This message drives me nuts! I query records into a block, but when I try to update or delete a record,
the FRM-40657 message appears.

Anyone know the solution. I need a solution ASAP

Thanks

MOnte
Re: FRM-40657 Record changed or deleted by another user [message #375346 is a reply to message #375344] Fri, 01 September 2000 12:29 Go to previous messageGo to next message
Robert Burke
Messages: 2
Registered: July 2000
Junior Member
Monte,
Check to see whether the table (referenced by the block in question) has one or more database triggers. Then check whether the column(s) which are being updated by the trigger matches any of the columns which are exposed in your block. If so then the problem is that your form is trying to update the same column(s) as your trigger. Fix this by removing the column from your block or by changing the trigger(s) so that it doesn't update the column.

Good Luck
Re: FRM-40657 Record changed or deleted by another user [message #375360 is a reply to message #375344] Sun, 10 September 2000 11:39 Go to previous message
Surendra K
Messages: 8
Registered: September 2000
Junior Member
Hi monte,

The problem is basically with the concurrency, that means u have queried records into ur block and before u could change and update another user has queried the same set of records and updated into the database.

This error message is correct, therefore don't get worried and u can't handle it in any way.
Previous Topic: Using Menu security in Forms 6.0
Next Topic: Run MS-Dos commands from Forms 4.5
Goto Forum:
  


Current Time: Mon Aug 03 04:30:26 CDT 2020