Good day
==-=-00-=-0=

I also believe this is not suppose to have an effect. Basically it has always worked
with the Normal TQuery component. Now that I am converting to IBOBjects I am getting this problem.

Thus basically I believe there must just be something small that I am missing as I believe
IBOBjects are more supperior to TQuery

Thanks

Johannes
At 12:29 24/09/2005, you wrote:

>--- In IBObjects@yahoogroups.com, Lester Caine <lester@l...> wrote:
>> Johannes Pretorius wrote:
>>
>> > Good day
>> > =-00=--0=
>> >
>> > Thanks for your feedback.
>> >
>> > As far as I know we have successfully in other programs edited the
>primary keys.
>> > We don't have GetText events. But THANKS for the tip as we might
>have spend
>> > ours on it in the future if we going to use it.
>>
>> Just a thought - since you are changing the very thing that is used
>to
>> manage data in the IBO cache!
>> Apply the update via a separate SQL component, and then refresh and
>> update the the main view by locating the new values you have put in.
>> That way the cache of data will not get upset by the new values and
>you
>> know where you are going to ;)
>
>I can not see why the IBO auto created Update statement would fail in
>this case either with cached updates on of off. For me, like for you
>Lester, I dont use cached updates. But - the statement looks lik this:
>
>UPDATE TABLE
>SET FIELD = :NEW_VALUE
>WHERE FIELD = :OLD__VALUE
>
>so even if we change the PK it should work. I surely do a lot of PK
>updated with the IBO auto gen statements. Diff from the original
>poster is I use native and no cached, though.
>
>I agree that your suggestion is a plausible workaround, though.
>
>/Dany
>
>
>
>
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
>http://www.ibobjects.com - your IBO community resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>--
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.344 / Virus Database: 267.11.4/109 - Release Date: 21/09/2005

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.4/109 - Release Date: 21/09/2005