I've got a class (a component), which executes a stored procedure (through a command object). The component "Requires Transaction" and it's called from "Supports Transaction" component . That stored procedure contains some SQL commands (INSERT/UPDATE). When the stored...
Hawran - addendum.
I've found out that any potential error in an SQL batch, which is executed inside ONE component (in a loop), WILL NOT cause roll-back of any SQL command executed before! Is it normal?
I've got two classes(two components in one DLL): clsA a clsB. Both clsA and clsB "Require transaction". The class clsA has got the only one public function which executes SQL command, passed to this function as String parameter. Another parameter passes an opened DB connection object...
Hi,
I have these problems:
1: I have an ActiveX DLL component (VB6+SP5, ADO 2.7) developed for executing of stored procedures in a DB(MS-SQL2000). That component is installed within COM+ (W2K+SP2). When I used default option for "Transaction support" (option 'Supports'), it worked...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.