How to execute a stored procedure multiple times using arrays?

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

Article #5258

Back to borland.public.cppbuilder.database.ado Previous Next

#5258

From: Changsong Bu
Date: Wed, 27 Jun 2001 13:15

9 lines
1491 bytes

I wonder whether you can execute a stored procedure multiple times by using
arrays of parameters? The procedure will be very simple, just an insert and
error checking. However it needs to be called very frequently, like once
every second. I hope to be able to call it once every 15 minutes, supplying
all the data in an array. In SQL Server books on line they talk about
column-wise parameter binding or row-wise parameter bing, which you can use
to execute a statement multiple times, in ODBC. But the syntax doesn't work
in C++ builder. Anyone has any idea about it? Thanks very much in advance.
Changsong

Technical Details

Message-ID: <3b39dc7d$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,4239602cd947ba7e,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-27 06:18:52 PST
Reply-To: "Changsong Bu" <cbu@idax.com>
From: "Changsong Bu" <cbu@idax.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to execute a stored procedure multiple times using arrays?
Date: Wed, 27 Jun 2001 09:15:22 -0400
Lines: 11
Organization: Idax
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 199.10.116.249
Message-ID: <3b39dc7d$1_1@dnews>
X-Trace: dnews 993647741 199.10.116.249 (27 Jun 2001 06:15:41 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews