Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Who has a table
Message
From
15/09/2000 10:40:32
 
 
To
15/09/2000 10:01:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00416847
Message ID:
00416892
Views:
23
FoxPro Advisor had a few articles in recent months which address this issue. I don't remember all the details, but I think one of them involved keeping a table of open tables.

The one which seemed more practical, though, was building a timer into your app which allowed you to kick out everyone in the system, so you could gain exclusive access to the data. Every few minutes or so, the timer would look for a trigger - perhaps a file - which would tell it to quit the app. It would display a warning message to the user, give them a period of time to quit, and then quit, so you could have exclusive access. I haven't tried it yet, but it sounds like a pretty solid philosophy.

>Where might I find code or a utility that a VFP application can request who has a particular table open and allow the application to "kill" the file association or connection?
Previous
Reply
Map
View

Click here to load this message in the networking platform