Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I use INSERT-SQL in multiuser
Message
From
21/07/2006 00:47:31
 
 
To
20/07/2006 11:24:51
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137935
Message ID:
01138299
Views:
11
Can you help me? I am working on ERP presently I use APPEND BLANK and REPLACE with RLOCK(), my company is devided in 7 different units which are located in range of 15 to 20KMS where some times network work very slow as well as break the link for few seconds. RLOCK() is taking lot of time to lock a record some time, during this if network breaks a link the DBF become corrupt. Can INSERT INTO is usable and can solve the problem in this situation? As per my knowledge it will be faster than RLOCK() & REPLACE. I think now you can understand my problem. Please give me solution if you know? How can I prevent my DBFs to become corrupt?

Jignesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform