current Record after insert/post of SmartQuery

[mxwx]

Hi,

I have expected that when I insert a record to a table the corresponding component(s) will automatically puts the cursor to this record. I have a SmartQuery to which I insert a new record and finally post this record. What do I have to do that the SmartQuery is pointing to the currently inserted record after the post. As of now the SmartQuery points to the record that is selected before the insert. I have tried any combination of the RefreshOptions and the FullRefresh too.

Thanks in advance

[Plash]

We could not reproduce the problem. Please send to odac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.
Also supply us the following information
- exact version of ODAC including build number (see Oracle | About ODAC in the IDE menu);
- exact version of Delphi.

[FanderlF]

Hm You could just save your primary key before insert/adding a new dataset and relocate the old dataset via the Locate function.