Hello Lauchlan,

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

LM> ok, after I do this the changes are made but the query dataset is closed. I
LM> take it one is meant to reload the query oneself to retrieve the changes?
LM> If so, what kind of strategies do people use to remember the cursor and page
LM> scroll position in the grid and go back to there after the reload?

You could use long-lasting read-committed read-only transaction to get
data for showing, and short-lasting concurrency transaction for data
modification: after modification you commit short-lasting transaction
and refresh data in long-lasting transaction. That's the way FIB+
offers (usage of two separate transactions for components like
TFIBDataset). I don't know if IBO offers the same. AFAIR, IBX supports
one transaction per data access component, so you should implement
separate transactions manually with that.


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com