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.....
|
|
|
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
|
|
|
|
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
|
|
|