Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pack while tables are shared
Message
From
22/12/2002 21:02:50
 
 
To
22/12/2002 19:22:01
Ransome So
Ransome's Workshop
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00735306
Message ID:
00735311
Views:
8
Put an ON ERROR command before trying to open the table exclusively. Something like this:
LOCAL IsOpen
IsOpen = .T.
ON ERROR IsOpen = .F.
USE MyTable EXCLUSIVE
ON ERROR

IF NOT IsOpen
   MessageBox ("Can't open the table. Please try again later.")
ENDIF
HTH

>In my project, 3 computers connected by LAN share one set of tables by set the tables exclusive off.
>
>The problem found when the main computer perform a table packing. Since the tables are shared and opened by the client computer. The main computer report table open error when packing proceeds. How can I solve such a problem ??
Previous
Reply
Map
View

Click here to load this message in the networking platform