Subject | Re: Updatable TIB_Cursor |
---|---|
Author | achidan |
Post date | 2004-03-01T19:52:12Z |
I wrote:
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
> When trace my SQL then I find the following update statement:I found now out that I can set the property SearchedEdits to true, so
>
> UPDATE Table1
> SET Field1 = ? , Field2 = ? , Field3 = ?
> WHERE CURRENT OF C17162776976181598
>
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