Thanks heaps Helen :)

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



Helen Borrie wrote:

> At 09:33 AM 27/01/2005 +1300, you wrote:
>
> >Hi All
> >
> >This is probably a silly question but ...
> >If I am using a TIBOQuery component, how do I override the prepared plan
> >with my own?
>
> Just include it in the correct place in your SQL as a PLAN clause. It's
> the last clause in the statement, other than ORDER BY, which has to
> follow
> any PLAN clause.
>
> e.g.
>
> select first_name, last_name from employee
> where last_name starting with 'J'
> PLAN (EMPLOYEE INDEX (NAMEX))
>
> Helen
>
>
>
>
> ___________________________________________________________________________
> 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 !
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/IBObjects/
>
> * To unsubscribe from this group, send an email to:
> IBObjects-unsubscribe@yahoogroups.com
> <mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>

[Non-text portions of this message have been removed]