Subject Re: [IBO] DML-Caching does not work when changing the prim. Key Value?
Author Jason Wharton
Part of my design intent was to track old and new column values which should
allow for key changes.
I agree someone using DML caching should not have PK values changing anyway.

Jason Wharton
CPS - Computer Programming Solutions
Mesa Arizona
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Thomas Steinmaurer" <ts@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, March 20, 2003 2:06 PM
Subject: RE: [IBO] DML-Caching does not work when changing the prim. Key
Value?


> Hello Jason,
>
> > You are probably doing something wrong.
>
> I am not sure here, despite the fact that it is a bad idea
> to have primary key column filled with "business" data.
>
> A quick look in TIB_BDataset.DefaultDMLCacheReceivedItem shows
> that for DMLCacheItemType=ditEdit InvalidateBookmark is called,
> which doesn't give the expected result, when the primary key
> column (used as KeyLinks) is changed.
>
>
> Regards,
> Thomas Steinmaurer
> http://www.iblogmanager.com
>
>
> > -- We may not have it all together --
> > -- But together we have it all --
> >
> >
> > ----- Original Message -----
> > From: "mag_jung" <magjung@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Thursday, March 20, 2003 4:01 AM
> > Subject: [IBO] DML-Caching does not work when changing the prim. Key
Value?
> >
> >
> > > Hi,
> > >
> > > I use the TIBO... TDataset descendants and havea little problem with
> > > the following situation. I have very few tables that have a primary
> > > key consisting of letters (currencies for example, USD, EUR, ...). If
> > > I edit such a field, all other datasets are notified of the change
> > > but the changes aren't reflected. All other field-changes are
> > > reflected.
> > >
> > > I do in
> > >
> > > proc OnDMLCacheReceived...()
> > > begin
> > > IB_Dataset.DefaultDMLCacheRe...;
> > > ibqryMyTDataset.Resync([]);
> > > end;
> > >
> > > Is this simply unsupported or am I doing something wrong ?
> > >
> > > best regards,
> > > Magnus Jungsbluth