We help IT Professionals succeed at work.

paradox problem...pls help?

lbseong
lbseong asked
on
dear every experts ...
  currently i c\got a problem..is always saud that this problem is control by another  .Net file so cannot view or canot run..and i have to stop the program and i have to delete all the .Net from the c directory...actually what is happening to this program?
  can somebody help thanks....
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2004
Commented:
the net-dir entry in the bde admin must point to the same shared network-directory for all clients

Commented:
There are two problems with using paradox with multi-user applications, record locking and index corruption, the solutions are as follows.
To solve the record locking problem, make sure the following line of code is executed before you open any tables.
  Session.NetFileDir := PathToMyData;  


The second problem is caused when you use TTables to edit your data. It occurs when alterations have been made to the underlying data, and then the application is abnornally terminated (ie, power loss). The solution to this is to make sure the all alterations are written to the database immediately.

Step 1 is to include DBIProcs in your USES clause.
Step 2 is to include the following code after

Posts
Deletes
Inserts
DbiSaveChanges(MyTable.Handle);  

Or you could just learn to use TQuery instead, which doesn't have the same problems :-)

Commented:
Well as kretzschmar said it has to do with the PDOXUSRS.NET file. Open the BDE > Configuration > Drivers > Native > PARADOX. Now look in the window pane on the right side you should find this entry "NET DIR". This tells you were this file is to and all the clients BDE on the system should be pointing to the hosts directory.


The Crazy One

Author

Commented:
thanks for ur help

Explore More ContentExplore courses, solutions, and other research materials related to this topic.