Subject | Very special Edit (Locate) question |
---|---|
Author | T.Stamm@eckelmann.de |
Post date | 2001-02-21T17:40:30Z |
I have an very special problem:
I'm using an TIB_Query selecting an subset of records,
now i have to change an record out of the same table as my query,
but that record is not in the result set.
Is there an possibility to change such an record, without having to
write my own update statement or change change my 'where' clause
first fetching that record an changing afterwards.
(The record has an unique key an I know the key).
I tried alread to change the key field values like:
KeyFieldByName(FKey).asInteger := FKeyValue;
but that changes are always overwriten by:
TIB_BDataset.SysUpdateKeyData
is there any solution for that ?
Regards
Thomas
I'm using an TIB_Query selecting an subset of records,
now i have to change an record out of the same table as my query,
but that record is not in the result set.
Is there an possibility to change such an record, without having to
write my own update statement or change change my 'where' clause
first fetching that record an changing afterwards.
(The record has an unique key an I know the key).
I tried alread to change the key field values like:
KeyFieldByName(FKey).asInteger := FKeyValue;
but that changes are always overwriten by:
TIB_BDataset.SysUpdateKeyData
is there any solution for that ?
Regards
Thomas