Update statement on button [message #451677] |
Fri, 16 April 2010 01:49 |
namb
Messages: 35 Registered: September 2009
|
Member |
|
|
I try to apply update statement on the button for the specific records, the command does executes if in the end i write execute_query it always asks for do u wanna save the records, yes or no. I want to remove that message. Also if i write commit it does remove that message but everytime i press the button it updates the old record fine but also adds one more entry for the same record. Can someone guide me abt the duplication why it is happening.
Thanks in advance
|
|
|
|
|
Re: Update statement on button [message #451841 is a reply to message #451824] |
Sat, 17 April 2010 07:08 |
shaz
Messages: 182 Registered: June 2009
|
Senior Member |
|
|
COMMIT statement is used to end the current transaction and make permanent all changes performed in the transaction.
COMMIT makes permanent any database changes you made during the current transaction. Until you commit your changes, other users cannot see them. Hence Commit is needed after you apply update.
N.B.: A transaction is a sequence of SQL statements that Oracle Database treats as a single unit.
|
|
|
Re: Update statement on button [message #451842 is a reply to message #451677] |
Sat, 17 April 2010 07:11 |
kojot
Messages: 27 Registered: December 2009 Location: Poland
|
Junior Member |
|
|
If you update using just sql statement, you should use 'standard.commit', but, if you change value in forms by text item, then use 'commit'.
If forms inserting a new records, while you think it should update, you should redisgn your form as Littlefoot suggest.
|
|
|
|