At 18:40 21.02.2001, you wrote:

>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).

Why not write an SQL update. It's probably the easiest and cleanest
solution (even if you didn't wat to use it)
Update <tablename> set <fieldname> = <value>
where <UniqueIDColumn> = <Keyvalue>

>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
>
>
>
>
>
>
>
>
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/