🚀 go-pugleaf

Hi,

Have you prepared the stored proc at design/run time??  Just like a query,
you could do a ADOStoredProc->Prepare() once and that should eliminate the
out of bounds problem...  (or at design time, you could extract the
parameter definitions).

Philip

"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/
>
>