Subject Re: Updatable TIB_Cursor
Author achidan
I wrote:

> When trace my SQL then I find the following update statement:
>
> UPDATE Table1
> SET Field1 = ? , Field2 = ? , Field3 = ?
> WHERE CURRENT OF C17162776976181598
>

I found now out that I can set the property SearchedEdits to true, so
that the update statement is using the KeyLinks to update the row. Now
it looks like that

UPDATE Table1
SET Field1 = ?, Field2 = ?, Field3 = ?
WHERE ID = ?

which seems to be correct.

But the value provided for ID is always 0. Why? When I do

ShowMessage(cur.FieldByName('ID').AsString)

then I get a correct value for ID. So the correct ID is in my cursor
but not it seems not to be in the Old_ID.

Any suggestions?

Thanks a lot
Daniel