"Index is out of date..."

[cc]

Hello to evereone,

I have a problem, hope someone can help me because i'm going mad.

I'm using Delphi 1 (16 bits) with paradox ver 1.0 and BDE ver 2.5
my aplication is working in a network where i have the database in a Novell
3.12 server beeing shared by the users and the aplication itself is
installed on the users machines.
Everything is working fine in this configuration.

But now we moved to a Nt 4 server with the service pack 5 and.
And in a particular case when tow users or more open a certain table, when
the second user tries to open it , it will give an error saing "Index is out
of date"
Doesnt matter if i reindex and purge, it always gives that error.

Why does it only hapen with the NT 4 Server and not with Novell 3.12
The files and configuration are the same in both cases.
Is there any compatibility problems with NT and paradox or delphi

Thanks in advance.

[Dave Porter]

Visit this web site for a relevant discussion Dave

http://www.itecuk.com/delmag/paradox.htm

[Ernie DeVries]

This sounds like the classic "Opportunistic Locking" problem. NT caches
disk writes when this is active (which is the default) and this results
in the table and indexes becoming out of sync with each other. There is
a KnowledgeBase article on this at www.corel.com. Just do a search in
the KnowledgeBase for the subject "Opportunistic Locking". Once you
turn it off you'll have no problems (and probably won't be able to
detect any performance difference either!).

[Dominic Garner]

Had this problem myself.

It can be as mentioned, opportunistic locking on NT or in my case
LOCALSHARE not being set to TRUE on all clients in BDE or a combination
of both

Hope this helps
Dom

[SIG]

Dominic Garner <d...@keyit.demon.co.uk> wrote in message
news:392A7EC4...@keyit.demon.co.uk...

I'm bothered by that problem too.
It's seems no difference, which platform you are use (my was WIN95, later
WIN98). I think , that this is
the problem in BDE engine itself, not because of system cache or timezone.
I developped a small database for multiple user access, using a Paradox
native BDE drivers, and
all is good for anyone in the net, before two different users start posting
changes in same tables at same (almost same) time.
Table index is going out of date. And my users screams in pain!!
I dropped an indexing (.px) files and restructured table again. Not helps.
Then i decided to not use the table indexing, and all became seems fine.
But: without indexing i have difficulties working with database (more
complex algorythms, more code , more buggy program).
So i decided never use a PARADOX engine for building a databases.
Better using more slower , but more stable dedicated SQL servers (INTERBASE
at least). Of course , this requires having installed a server and
understanding how to work with it.

> Hope this helps
> Dom