--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:

> That one is just tooooo simple. If your SQL statement starts with
> SELECT, you use Open (or, in the case of IB_Cursor, First).
>
> All other SQL statements, use Execute.
>
> Btw, don't use IB_Query/IBOQuery for executable statements. Use
> IB_DSQL (best) or IB_Cursor. Because executable statements are not
> linked to visual controls, there's no problem using these

components with TIBODatabase as their IB_Connection.

>

Thank you Helen

I will take your advice.
As a matter of interest, does using IB_DSQL give a speed advantage
over IBOQuery or is there a different reason?

As I mentioned previously I recently converted from BDE to IBO & to
date I have mainly used TDatabase/TQuery with TListView's. Is there a
document/write-up suggesting which IBObject components should be used
under what circumstances?

Jack