> To make the IBQuery editable, you will need to attach a TIBUpdateSQL
> component to the query,
> set cachedupdates to true and generate the SQL statements necessary within
> the TIBUpdateSQL
> statement.
>
> The TIBUpdateSQL component can link to one of the tables in the query and

if

> the query would normally
> return a readonly dataset and will allow you to update this table.

> You will need to the applyupdates and Transaction.Commit commands at some
> point to actually save
> the edits you have made in the grid.

ok, after I do this the changes are made but the query dataset is closed. I
take it one is meant to reload the query oneself to retrieve the changes?

If so, what kind of strategies do people use to remember the cursor and page
scroll position in the grid and go back to there after the reload?

Thanks,

Lauclan Mackinnon