Subject Re: [IBO] Programmatically grant role to user
Author jackmills75
--- In, 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?