🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1091

ADO script

#1091
From: Julian Lliteras
Date: Tue, 21 Dec 2004 12:22
29 lines
1395 bytes
Hi,

I must execute many statements in a transaccion. Is TADOCommand capable to
execute an script like this:


declare @resgen integer
declare @resin integer

set @resgen = 0
set @resin = 0

BEGIN TRANSACTION

exec sp_da_num_res @resgen OUTPUT ,@resin OUTPUT

select @resgen,@resin
.
.
.
.
.
COMMIT TRANSACTION


Can I take control of transactions inside the script?


Thanks.
Technical Details
Message-ID: <41c8159a@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.zanker.org!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,87bb2defd0d92654,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Julian Lliteras" <yartax@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO  script
Date: Tue, 21 Dec 2004 13:22:49 +0100
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 213.96.91.217
Message-ID: <41c8159a@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1103631770 213.96.91.217 (21 Dec 2004 04:22:50 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.zanker.org!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail