search and update [message #546996] |
Sun, 11 March 2012 01:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/c86fedf38fdae46febdd4144bf66e65d?s=64&d=mm&r=g) |
furqan
Messages: 115 Registered: January 2012 Location: Hyderabad
|
Senior Member |
|
|
hi
i hav a table in database with name TBH.in that table there are 25 to 30 columns.its a material details table.
by using add material form i insert all the details of the material in the table.2 colums have primary key(material id and material code).
now iam making search and update form.on material code item i have WHEN-MOUSE-CLICK-TRIGGER and calling LOV and displaying
record.
but the problem is when iam making changes in some fields its giving error ...UNABLE TO INSERT....FRM-40508:ORACLE error:unable to insert record.
when i check display error its showing
ORA-00001: unique constraint (DETA.SYS_C006356) violated..
please help...
|
|
|
|
Re: search and update [message #547005 is a reply to message #546997] |
Sun, 11 March 2012 05:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
You haven't populated the block using execute_query have you?
I assume you've written a select statement to manually populate the block.
Do that and forms thinks all the records are new records and will try and insert them when you click on save.
|
|
|