Paradox 7 Data Loss

[Streetcat]

I wrote an application using Delphi 6 and paradox 7. This application runs on a windows network. But for some reason I "lose" some of the data. I might add a record to a file ( with an autoincrement record ), and 10 min later add a new record and then the first record would be missing. The second record has the same autoincrement number as the first record. This happens to all the files I use. It works about 90 % of the time, just sometimes it goes wrong.

My delphi commands are ...

table1.append;
... adding my records ...
table1.post;

I am not using cacheupdates ( on my tables ) and my pdoxusers.net file are all set up correctly.

The funny thing is even if I only use one of the computer I get this to happen, so I am not sure if it is to do with cache. There are 3 computer on this network, winxp/win 2000 and win 98. The data sits on the xp computer.

Please assist clever people out there ...

 

[towerbase]

Paradox was originally designed as a single user database and the multi user enhancements were a bit of a kludge. I used to find Paradox unreliable especially on a network.

I would recommend switching to a good multi user database. I use MySQL (because it reliable, good, fast and free) but there are others such as Interbase, MS SQL Server, Oracle and so on which are probably just as effective.

You'll save time in the long run by using a proper DBMS. It will improve your career prospects if nothing else

If you are still intent on sticking with Paradox then I suggest that you flush the IO buffers after each insert.

Andrew
Hampshire, UK