🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Incorrect documentation for TADOStoredProc

#4731
From: Graham Reeds
Date: Thu, 22 Nov 2001 12:45
23 lines
1785 bytes
I'm trying to get parameters passed via TADOStoredProc.

I've tried the example from the Borland Help Files but that gives a "E2288
Pointer to structure required on left side of -> or ->*" compiler error
message.

I've also tried
        ADOStoredProc->Parameters->Items[0]->Value = PROJECT_ID;
yet that generates a runtime error of ListIndex out of bounds (0);

I've tried several variations on this theme yet nothing is working.  Anybody
got any working suggestions?

What I am trying to do is speed my application by replacing the INSERT
statement that is parsed everytime (and ergo very slow) with a stored
procedure that will reuse my the cursor and hopefully make it faster (it
currently takes about 15 mins to insert a test suite of 100,000 records and
I would like to reduce that substantially.

--

Yours faithfully, Graham Reeds.
grahamr@omnieng.co.uk | http://omnieng.co.uk/
Technical Details
Message-ID: <3bfcf383_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!209.98.98.64!news-out.visi.com!hermes.visi.com!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,68b49c4782325fc3,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-22 04:55:25 PST
From: "Graham Reeds" <grahamr@omnieng.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Incorrect documentation for TADOStoredProc
Date: Thu, 22 Nov 2001 12:45:38 -0000
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 212.172.148.2
Message-ID: <3bfcf383_2@dnews>
X-Trace: dnews 1006433155 212.172.148.2 (22 Nov 2001 04:45:55 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!209.98.98.64!news-out.visi.com!hermes.visi.com!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews