Multiple commands using tADOCommand

From: Hans van Leth (hans.v.l)
Date: 11/26/03 

Date: Wed, 26 Nov 2003 19:04:07 +0100

Hi,

D7 help says on tADOCommand: "One command may be executed at a time"

How can one execute something like:

begin transaction
update table1 ...
delete from table2 ...
commit transaction

Using MS-SQL or MS-Jet as the back end.

Thanks!

Hans van Leth.

Relevant Pages

  • Re: Call SqlCommand.ExecuteReader inside another SqlCommand.Execut
    ... Do you mean that you are concerned that a row of interest in table2 could be ... updated after you execute the select on table1 but before you execute the ... begin transaction; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Concurrent Connections / Shared Transaction
    ... In MARS there are fixed interleave points in the server. ... Do you mean that one will execute and ... bound sessions allow you to share the transaction space among ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: HOWTO: Use conditions in FROM clause in Access sintax.
    ... If you execute them in SQL Server I ... and that means that I need all rows in Table1 and only matching one in ... >> Table2 Ref RefExt RefTwo Data ...
    (microsoft.public.access.queries)
  • Urgent problem: Any help greatly appreciated
    ... I am trying to execute a number of SQL stored procedures in a single ... I really need to be able to execute these procedures in a single transaction ... SqlTransaction trans; ...
    (microsoft.public.dotnet.languages.csharp)
  • Urgent problem: Any help greatly appreciated
    ... I am trying to execute a number of SQL stored procedures in a single ... I really need to be able to execute these procedures in a single transaction ... SqlTransaction trans; ...
    (microsoft.public.dotnet.framework.adonet)