Subject Re: [IBO] Simple question about inserts
Author Helen Borrie
At 10:49 PM 2/08/2005 +0000, you wrote:
> I am inserting into a table some data.
> After it, i invalidate the row to get the refreshed data. The
>problem is: after i do that, the position from the data goes to the
>begin of the dataset. How can i store the old position when it was
>before the invalidate row?
> Sorry for poor english and thanks in advance for attention.

If you are using TIB_Query, the RefreshAction property is what you want to
look at. Read the help for TIB_RefreshAction. The setting you probably
need here is raKeepDataPosOrRowNum.

If you are using TIB_Cursor, the behaviour you are seeing (raOpen) is the
only one possible, since TIB_Cursor does not buffer the dataset.