OraFAQ Forum: Forms » unable to update a record

Home » Developer & Programmer » Forms » unable to update a record

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

unable to update a record [message #79585]

Mon, 24 June 2002 02:08

sumit deb
Messages: 1
Registered: June 2002

Junior Member

i have written a when button pressed trigger to update a particulat column in forms 6.0. I have just written an update statement .....

When i run the form.....it gives me an error ..
"Unable to insert the record"........actually it tries to insert a whole new record with the updated details....and that's why it is violating the primary key constraint ....but why is it trying to insert a new record when i am just trying to update a single field.

please help me.....

Report message to a moderator

Re: unable to update a record [message #79586 is a reply to message #79585]

Mon, 24 June 2002 02:41

Ani
Messages: 56
Registered: November 2000

Member

Hi Sumit,
pls check for the :system.form_status. mostly instead of being in 'QUERY' it is in 'INSERT'. r u assigning any value anywhere in post-change or key-next?
pls check.
All the best
Ani

Report message to a moderator

Re: unable to update a record [message #79589 is a reply to message #79585]

Mon, 24 June 2002 03:23

Remash
Messages: 52
Registered: November 2000

Member

Hi

Before COMMIT_FORM or COMMIT, clear the block using CLEAR_BLOCK(No_Validate)

Regards

Report message to a moderator

Re: unable to update a record [message #79594 is a reply to message #79585]

Mon, 24 June 2002 08:28

Tyler
Messages: 123
Registered: January 2002

Senior Member

If you are trying to update, you have to be executing a runtime where_string and then just using commit_form... but if you are doing a manual coded update
statement then the block can not be a database block, it has to be just a stand alone anonymous block or the database will see the database items changed and assume that an insert is taking place and try to accomplish an insert.

if the previous replies didn't help, I hope this did...

Cya
T

Report message to a moderator

Previous Topic:	Reg clear block
Next Topic:	problems in menu

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 12:46:43 CDT 2025