Subject Re: [IBO] Stay on newly inserted record
Author Helen Borrie
At 03:36 PM 27/02/2005 +0100, you wrote:

>hello all,
>I'm using a TIB_Query and I have CommitAction = caRefreshKeys and
>= raKeepRowNum. With this combination the dataset returns to the previous row
>after a new record has been inserted but I'd rather like to make the
>dataset to
>stay on the new record after an insert. Is there any property to set or any
>trick to do this?

raKeepRowNum (correctly) takes you back to the record you were on before
you started inserting. In the case of an inserted record, there is no
"previous row number" for it to go back to.

Use raKeepDataPos to ensure that the buffer cursor is on the newly inserted
row after the refresh. To get one or the other, depending on whether your
last committed operation was an insert or an update, use raKeepDataPosOrRowNum.