hi has anyone recompiled ibo3 for delphi seven

Regards;
Ettienne du Plessis
Senior Analyst
First National Battery CO (PTY) LTD
Tel : +27 11 741-3600
Fax : +27 11 421-2739
Web : www.battery.co.za


-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 10 May 2003 11:23
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] TIB_StoredProc management question


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.




___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/