PDox table locking problem, or disk cache?

Chris H

Delphi Developer

Sat, 21 Sep 2002 03:00:00 GMT

PDox table locking problem, or disk cache?

I have a multi-user app using D4 and PDox tables - under Win98 (at least) I
lock a file from one pc, but second pc does not "see" the lock.
Running the app twice on same pc (which also contains the shared data dir
and the .lck files etc), the second instance of the app "sees" the lock, and
gives me an Exception from the TTable.LockTable() as I expect, so I can give
the user a "busy..try later" message.
Help!
Is this a BDE issue, or local disk caching of some sort...where do I go from
here please?
Thanks
Chris ("Buzz")

Brian Bushay Tea

Delphi Developer

Sat, 21 Sep 2002 03:00:00 GMT

Re:PDox table locking problem, or disk cache?

Quote

>I have a multi-user app using D4 and PDox tables - under Win98 (at least) I
>lock a file from one pc, but second pc does not "see" the lock.
>Running the app twice on same pc (which also contains the shared data dir
>and the .lck files etc), the second instance of the app "sees" the lock, and
>gives me an Exception from the TTable.LockTable() as I expect, so I can give
>the user a "busy..try later" message.
>Help!
>Is this a BDE issue, or local disk caching of some sort...where do I go from
>here please?

Make sure Local Share is set to True
That the network control directory setting uses the same Path on all
workstations and that you do not use a root directory for the location of the
network control file.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. Do cached updates use Pdox- or Inmemory-Tables?

2. Max locks on a Pdox table

3. Cached updates from table to disk

4. Change table type Pdox 4 to Pdox 7

5. problem cache / disk data

6. Possible Disk Cache Problems with BDE under Windows NT

7. Cached Update Locking Problems

8. Problems with Pdox table on read only network resource

9. Calculated Field Problem. Delphi w/ Pdox 4.5 Table

10. Problem doing OUTER joins w/ pdox tables