HELP: call_form cannot commit an SQL insert statement

Hi guys
i'm having this problem with commiting an SQL statement (in a form procedure)
scenario:
i have formA calling formB and a procedure in formB that inserts and commits a record into an audit table, eg.

    insert into tableB values('a','b','c');     commit;

however, i can only commit the record if i'm in a new record in formA and double-click to trigger the call to formB. if i were to trigger it from an existing record in formA, record would not be commited in formB. strange thing is it did not return any error, exception was not triggered. i even displayed the sqlerrm and err_text but all says ok.

further testing i found out if i were to call formB from an existing record and exit back to formA and then trigger it again in a new record in formA, it was not able to commit the record.

so it works only if i trigger it on a new record in formA and must not trigger it on an existing record even if i later trigger it on a new record

anybody has faced this problem. hope someone can help. appreciate if you also reply to my email at richard_tay_at_singstat.gov.sg thanks a million ;-) Received on Mon May 13 2002 - 18:11:40 CDT