At 02:12 AM 10/05/2003 -0700, you wrote:

> > > > >Then, do I call Open() or Execute()? Which is correct in this case?
> > > >
> > > >Call Open on an IB_Query. Call First on an IB_Cursor. Call Execute
> on an
> > > >executable (that has the EXECUTE PROCEDURE(...) syntax).
> > >
> > >What about an IB_Cursor using the EXECUTE PROCEDURE syntax?
> >
> >Same.
>
>Same as which? If I'm using an IB_Cursor with the EXECUTE PROCEDURE
>syntax, and I need just that one return value, and am not displaying the
>value in a control, would I use Execute(), or First()? Or does it matter?

Execute if you are calling EXECUTE PROCEDURE, First if you are calling
SELECT * FROM MYPROC(A, B)

> >If this is your design approach and you potentially have "stub" SQL
>
>What is "stub" SQL?

To use a very ordinary example,
SELECT * FROM EMPLOYEE

You modify that by applying SQLWhereItems (and/or SQLOrder) during your
OnPrepareSQL event. This is different to replaceable *parameters*, which
don't require a reprepare.

H.