Hi Sherry,
> We run the program to reindex our database every night, however, it will error out if somone forget to close one of the apps. I wonder if anyone knows how to capture the value from whohas command inside the vfp5.0? thank you.
We were unable to easily check for who has what open in an automated task. What we came up with instead, was to add a timer to our app that fires every 15 seconds to check for a value in our main control table. If the value was set to true, an auto-logout process was started. The user is notified that the "System Administrator has requested everyone to exit..." If no response within 5 seconds, auto-logout begins. This repeats every 15 seconds, so they really cannot get much work done. The auto-logout is disabled when certain tasks are started that shouldn't be interrupted. i.e. Running Payments.
This strategy has worked quite well for us.
HTH,
Bill Armbrecht
VFP MCP