Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can a table be open in two occurances of VFP?
Message
From
14/02/2003 12:20:52
 
 
To
14/02/2003 09:06:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00752841
Message ID:
00753311
Views:
12
>>>I want to simulate two users access the same table on my PC, i.e. open the same table in two instances of VFP 7. Can this be done.
>>
>>Absolutely - as long as neither is opening the table exclusively.
>>
>>Alan
>
>Thanks, I did the following
>
>open database dbcname shared
>use tablename in 0 shared
>
>in both instances, then I check result of rlock(tablename), in second instance get .f. if on the same record, .t. if on different record (as expected).
>
>Question does tableupdate work the same way?

It should. If one user has the record locked, the other user won't be able to update it, but as far as I know, tableupdate() itself only locks the record long enough to write it out.

Make sure you read up on CurVal() and OldVal() in the help to get a better idea of how to handle table updates on multiuser systems.

Alan
Previous
Reply
Map
View

Click here to load this message in the networking platform