he wants to update a record that is not part of the recordset that came back from his select statement
AND
he does not want to write his own parametrized update query.
he knows the key for the record he wants to change.

----- Original Message -----
From: Jason Wharton
To: IBObjects@yahoogroups.com
Sent: Friday, February 23, 2001 11:01 AM
Subject: Re: [IBO] Very special Edit (Locate) question


I am sorry but in my quick "once-over" that was actually two or three now, I
have not grasped what you are trying to accomplish. It's probably just me
but could you rephrase this?

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: <T.Stamm@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, February 21, 2001 10:40 AM
Subject: [IBO] Very special Edit (Locate) question


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


Yahoo! Groups Sponsor

Click here for Classmates.com


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]