Home » Developer & Programmer » Forms » Problem for FRM-40654
Problem for FRM-40654 [message #147771] Mon, 21 November 2005 00:06 Go to next message
atanu
Messages: 1
Registered: November 2005
Location: kolkata ,India
Junior Member

Hello Everybody ,

I face a problem when i want to update data in form. The error occured

FRM-40654: Record has been updated by another user. Re-query to see change.

for solution i add some data,also add new field through Benthic.Then delete that.then commit.

But when i open form and update any field ,the error occured.
Pls anybody give me the solution.

Atanu.
basuatanu@yahoo.co.in

Report message to a moderator

Re: Problem for FRM-40654 [message #149786 is a reply to message #147771] Mon, 05 December 2005 00:01 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You are changing data fields that are already populated, that is, you are assigning a value to a field that has already been populated in your form. Bad coding practice.

What triggers have you defined in your form? You DON'T have to write all the triggers that exist in the documentation. Start your form's code simply. Most of the work is done automtically for you by forms. Do you have a database trigger on this table?

David

Report message to a moderator

Previous Topic: Converting forms from 6 to 9i
Next Topic: How can I use HTML tags in D2K forms 6i pl/sql editor???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:34:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.