Home » Developer & Programmer » Forms » unable to update column (oracle developer 2k forms 6i and reports 6i)
unable to update column [message #342442] Fri, 22 August 2008 06:24 Go to next message
AMRESH
Messages: 7
Registered: August 2008
Junior Member
Sir,
I am using developer 2k forms 6i and reports 6i,there is one simple update statement which updates one column in the database.
this table has no on-update triggers on this column.
but at times it updates some time it does not update.
this code is within the form.

/*code*/
update vouch
set status = 'C'
where pv_num = :voch

commit_form;

please advise.
Re: unable to update column [message #343322 is a reply to message #342442] Tue, 26 August 2008 23:32 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
This is a MANUAL update therefore you need to do a MANUAL commit. 'Commit_form' is for automatic updates. Use 'standard.commit' for manual updates.

David
Previous Topic: calculation
Next Topic: my browser is closing
Goto Forum:
  


Current Time: Sat Dec 03 12:25:47 CST 2016

Total time taken to generate the page: 0.09573 seconds