Normally I have set the RefreshAction of my Queries to raOpen, because
it is the cheapest operation. For example, I have a large dataset with
many rows and order by name asc and then change the ordering to desc.
With raOpen the cursor jumps always to the first record and with
raKeepDataPos the cursor has to move to the last dataset. So far so
good, but when I insert a new record and post it ( I have set AutoCommit
to true), the cursor jumps to the first record with raOpen, but I want
the cursor to stay at the record, that I have inserted. So for changing
the ordering of a dataset I need raOpen and for editing the dataset I
need raKeepDataPos, but I don't know how combine these two things.
Any ideas ?


Guido