The BDE does it's own caching, as does the OS - though I don't think this,
ie writing to disk, is the issue. If you have two different TTable objects
I've found that later versions of the BDE aren't quite as good as they
should be about maintaining concurrency between the two datasets - even
though they should be looking at he same BDE Cache.
DbiSaveChanges(TTable.Handle) will force to write back to disk, but this
doesn't do the job either. Closing the dataset seems to be the only way of
forcing the BDE to update. Since loading Delphi 5 and BDE 5.01 I've also
noticed that some DataSet's that get destroyed without a call to Close also
tend to not post all changes, though I haven't tried to track down a
consistent pattern. The only solution seems to be to use a datamodule with a
single TTable for writes. This suggests that the TDataSet itself is
caching - even without cached updates.
If you create all your forms at sartup and only destroy your forms, and
therefore close your datasets, when the application closes - this may be the
explanation.
I've recently taken over an application that has Dataset.Close statements in
all the forms' Close Events - this behaviour may be the reason the4 author
resorted to this.
Hope something here helps.
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Matthew Comb
Sent: Wednesday, 27 October 1999 15:56
To: Multiple recipients of list delphi
Subject: [DUG]: Caching.
I think this is better suited to the DB section BUT...
I have a simple delphi app that is using a paradox database table. Nothing
flash, no SQL querying or anything.
I have always thought that when you move to another record the record that
you were on was saved. Well - When the user is printing a report it does not
reflect recent changes until the app is closed and then opened again.
Is some form of caching happening that I don't know about?
Cheers,
Matt.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
