Hi,

At May 7, 2003, 04:31, guido.klapperich@... wrote:

> 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 ?

What is your CommitAction set to? It's probably set to caRefresh, try
setting it to caInvalidateCursor.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)