Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Determining if Memo table is locked
Message
 
 
À
03/02/2003 15:03:08
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00748559
Message ID:
00748760
Vues:
17
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform