How do i set auto commit off in VB script if i use oraoledb driver? I want to do a transaction but the autocommit is on by default. Thanks.
m*t
2 楼
Why don't you just explicitly abort(or rollback) if anything goes wrong?
【在 s***m 的大作中提到】 : How do i set auto commit off in VB script if i use oraoledb driver? I want to : do a transaction but the autocommit is on by default. : Thanks.
s*m
3 楼
to I my case, i need to insert multiple tables. I want to either insert into all tables or no data is inserted. If i do rollback, it only rolls back the current insert. Previous insert will not be rolled back. Do i miss something? Thanks.
【在 m******t 的大作中提到】 : : Why don't you just explicitly abort(or rollback) if anything goes wrong?
m*t
4 楼
I'm not familiar with VBS, but there should be a way to explicitly demarcate a transaction, i.e., something like transaction.begin(), and at some later point either transaction.commit() or transaction.rollback(). At least that's how it works in Java with Oracle (and IIRC it's similar in ODBC as well).
【在 s***m 的大作中提到】 : : to : I my case, i need to insert multiple tables. I want to either insert into all : tables or no data is inserted. If i do rollback, it only rolls back the : current insert. Previous insert will not be rolled back. Do i miss something? : Thanks.