| unable to update column [message #342442] |
Fri, 22 August 2008 06:24  |
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  |
 |
djmartin
Messages: 10181
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.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
