-----Original Message-----
From: Orlando Pobre [mailto:Orla...@TRAMS.com]
Sent: Monday, January 19, 1998 6:29 PM
To: 'Luchian Teodoropol'
Subject: RE: Paradox corrupt file
I'm curious. How often does it happen to you. There are other rules
too that
you must follow.
1) Making sure that the Drive letter that is mapped is EXACTLY the same
at
every work station. Except the PC that has the database on the C drive
is ok.
e.g. Net Dir is T:\MYDATABASE ... must be T on every PC's BDE
2) BDE version 2.52
3) Local Share set to TRUE
4) Win95 - Disable New file Sharing and locking semantics
5) There may be more....
About guaranteeing that one person writes to a table:
Even though it is Multi-User, you can have a polling routine that locks
a file.
Any person that does the locking can do their Edit and Post and then
Unlock
that file (which would allow the next person to be able to do updates on
that
same table). There are algorithms you can try for this to improve the
chances
that one person will lock that file. The file locking routines can use
the
FileOpen function with fmShareExlcusive and poll for random intervals
and
check to see if you can lock that file again.
Luchian Teodoropol wrote:
> Hi everyone,
> here's my problem:
> I have a Paradox table that once in a while gets corrupted - usually
> in
> its header. This seems to be randomly but is very annoying and because
> of that our users don't have confidence in our software (and I don't
> blame them). I use Delphi 2.01and the table is used in a networked
> environment with about 6 users accessing it simultaneously. The table
> holds some temporary data, therefore a lot of deletion and insertions
> are performed on it. I've been under a lot of pressure to go in debug
> mode and find out where exactly the program/table crashes (?!?!?) - to
> be honest I really cannot do that since all I'm using are Delphi-BDE
> calls, but my supervisors wouldn't accept that - something has to
> wrong
> in my code and it has to be pinned out!
> I would appreciate any suggestion.
> Thank you.
> P.S. You may reply at luch...@easysoft-law.com
