session and savepoint

[ziller]

hello,

when i issue

i have a form

in the oncreate event i issue :

ora_session.savepoint("S1");

in the onbuttonclick event i issue :

ora_session.commit;
self.close;

in the onclosequery event how do i know that i'm in the S1 savepoint and that i have to do a commit or a rollback? (i cannot use intransaction because i've previously issued a S0 savepoint).

regards

 

[Marco Kalter]

You would probably need to keep track of the inserts, updates and deletes in this form. I don't think the database state can provide this information.

------------------
Marco Kalter
Allround Automations

 

[ziller]

i will make a wrapper around toraclesession that maintains a first-in-first-out list of the currents savepoints...