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