Does anyone know if cached updates in the BDE use
Paradox tables or in memory tables?

Thanks for your help!
                Dany

PS: When answering, please send me a mail too.
________________________    ________________________
Daniel Wyss             \  /      Opus Software GmbH
mailto:d...@opus.ch      \/       http://www.opus.ch

whenever you open a Ttable or TQuery with CachedUpdates = TRUE,
you'll get a Del(nnn).MB file, which is a paradox table (the "(nnn)"
is a three digit number, built sequentially from 001).  They get
placed in the executable's working or start directory.  if the working
or start directory is on a network drive, the paradox lock files are
also created, and a BDE Alias may be required (at least i had to
create one for everyone until i had everyone change the start
directory to their local drive).

Roy

I don't know if this is any help, but my suspicion is that it's an in
memory table. If you look in your Windows temp directory when you open a
TTable, a new file named "INMEMxxx.REM" gets created.

Also, look in the BDE help file under cached updates - there is a
section on the "cached updates layer". This section states that you
can't use DbiSwitchToIndex on the cached updates layer. Guess what - you
can't use DbiSwitchToIndex on in memory tables.

Hope this helps - let me know what you find out.

-Bryan

Isn't the MB file a paradox memo field file?

-Bryan