At 11:21 AM 18-12-02 +0000, you wrote:

>This is probably a stupid question with a blindingly obvious answer
>but how do you make the data retreived by a query form editable? When
>I open the query, the data is shown and the 'add' icon is enabled but
>the 'delete' and 'edit' icons are disabled. I am looking for a tool to
>replace Database Explorer which enables me to retreive live data
>using a query and to edit it, but uses the BDE. Using IB_SQL compiled
>with IBO 4.2Ib.

IB_SQL doesn't use the BDE.

If you want to make a query form updatable (edit, delete), go to the SQL
tab then across to the UpdateSQL tab. In there, check the update ops that
you want to have live and then click the Generate for Table button. IBO
will construct the statements and bingo! you're live next time you prepare
the query.

In some cases you might need to go to the KeyLinks tab (also on the SQL
page) and enter the unique key column(s) of the query.

Helen