At 03:58 PM 22/10/2004 +1000, you wrote:

> > >I hope this is clearer. Thanks again for your time.
> >
> > Yes: That is what I understood you wanted.
> >
> > It is dead easy. Either write a procedure to create the DSQL
> > at run-time, passing the parametrised EXECUTE PROCEDURE
> > statement as a string; or merely plonk one ib_dsql in your
> > datamodule, set it up with everything except the SQL, and
> > access it at run-time.:
> > Helen
> >
>
>Sorry Helen, but I would like to know why "> Forget about TIB_StoredProc"
>for future reference ;-)

Because it is loaded with a whole lot of stuff you don't use for executable
SPs. I believe Jason developed it to pander to some folk who didn't know
how to live without a StoredProc component. (Like the Queen needs another
hat!!) TIB_DSQL just rips in there and does the job without all the hoo-haa.

FWIW, a TIB_Query does a much nicer job than the storedproc component with
selectable SPs, as well.

Helen