Hello...

I've the problem to use a transaction structure in Visual Basic using
EXECUTESQL command. In other words I'm trying to do (in the environment in
object) something like this:

Begin transaction;

UPDATE EMP SET enumber TO 1234 WHERE ename = 'Smith';
UPDATE EMP SET enumber TO 4321 WHERE ename = 'Joe';

Commit;

...I want too much ? ...thanks in advance !

Alessio LORUSSO wrote on 11 Apr 1995 21:02:39 GMT:
:> Begin transaction;

:> UPDATE EMP SET enumber TO 1234 WHERE ename = 'Smith';
:> UPDATE EMP SET enumber TO 4321 WHERE ename = 'Joe';

:> Commit;

if you wanna use begintrans and committrans in VB, do a .Execute rather
then .ExecuteSQL. I discover VB's begintrans/committrans/rollback don
work with .ExecuteSQL

--
===========================================================================

+ National University of Singapore      Faculty of Engineering (EE Dept)  +
===========================================================================

It is logical. .ExecuteSQL sends passthrough SQL statement to an
independent server. Maybe you can use somehow stored procedures to
implement begintrans and so on?
Andrzej