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
Messages: 7
Registered: August 2008
Junior Member
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.

update vouch
set status = 'C'
where pv_num = :voch


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
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS 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.

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

Current Time: Mon Jul 24 02:21:20 CDT 2017

Total time taken to generate the page: 0.04539 seconds