🚀 go-pugleaf

Personally, never got a TADOStoredProc to work.  I use a TADOQuery instead.
The SQL Query is something like:
"BEGIN  MyProc( parm1, parm2, etc ); END;"

- Arnie

"Graham Reeds" <grahamr@omnieng.co.uk> wrote in message
news:3bfcf383_2@dnews...
> 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/
>
>