Subject | Re: [IBO] DML-Caching does not work when changing the prim. Key Value? |
---|---|
Author | Jason Wharton |
Post date | 2003-03-20T22:26:02Z |
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 --
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