Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Try to use table exclusive if not don't pull up open dialog
Message
From
15/08/2003 12:26:44
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Try to use table exclusive if not don't pull up open dialog
Miscellaneous
Thread ID:
00820570
Message ID:
00820570
Views:
71
I have each person that inputs transactions having their own seperate table they use. After posting their transactions from this temp table I want to use the table exclusive for a few seconds to pack and reindex it. The problem is that each user, while inputing transactions to their seperate tables, has to jump through each other person's to check really quick to see if the same account already has a transaction in another user's table. This uses the table shared and only for seconds at different times. There is about a 90% chance that the user can use their table exclusive during posting to do the pack and reindex, during the other time, I am not worried about it not doing it. Because of this I do the on error type thing to turn the error reporting off temporarly long enough to try to ignore the "... .dbf is current in use" error. This ignores the error from popping up, but I do get Open table dialog boxes that still pop up, even though I turned off the error reporting during this check. Is there any way to ignore this as well during this try at exclusive use?
``` Appreciate a normal day, it is always better than a bad one ```

Kev
Next
Reply
Map
View

Click here to load this message in the networking platform