Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Check if a table is open

Status
Not open for further replies.

corgette

Programmer
Mar 3, 2008
25
GB
I am trying to find a way to see if a table is open by another user.

I open the table, select a record and lock it.

Then in another window on the same computer, I open the table again as follows:

USE Table09 alias table EXCLUSIVE

FLOCK() returns .T. even though the table is open and a record locked in another window.

I can get into the table and open and lock a record. But if I try to use the same record being used in the other window, i cannot lock it.

1. Why can I open it EXCLUSIVELY ?
2. Why does FLOCK() return .T ?
3. Is using two windows the same as using 2 workstaions on a network ?
 
Sorry.

Please ignore this thread. It was the same table in 2 different folders.

1 for VFP, 0 for me.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top