Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determining if Memo table is locked
Message
From
04/02/2003 03:55:57
 
 
To
03/02/2003 15:03:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00748559
Message ID:
00748760
Views:
16
Miles, take a look at ISFLOCKED() to see if the table is locked or not.
Optimistic/Pessimistic is the type of buffering, you can use
lnBufferType = CURSORGETPROP("BUFFERING", "TABLENAME")
to work out which type:
1 = No buffering
2 = pessimistic row
3 = optimistic row
4 = pessimistic table
5 = optimistic table

I would assume that if the table/records are locked the memo will be locked as well. You could explicitly test using FOPEN() to see if the file is in use?

>Is there a function to determine if a table is locked, Without putting a lock on the table while testing. And can you determine the type: optimistic or pesimistic. And, can you test the if the memo table fpt is locked also.
- Craig

"If you're not prepared to be wrong, you will never come up with anything original."
- Sir Ken Robinson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform