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 ?
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 ?