Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to know the access mode of an open table?
Message
From
19/07/2011 03:50:41
 
 
To
16/10/2000 17:05:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00430015
Message ID:
01518490
Views:
46
>>After I opened a table, how can I know which access mode (EXCLUSIVE or SHARED) was used?
>
>NOUPDATE is another access mode you may need to look for, you can use IsReadOnly() for that.

Hi,

I have found this (possible incomplete) list:
*Locks current record   
APPEND              
APPEND MEMO          
DELETE               
DELETE NEXT 1       
GATHER              
RECALL                 
RECALL NEXT 1
  
Locks record <n>      
DELETE RECORD <n>   
RECALL RECORD <n>  
 
*Locks current record (and all records from aliased fields)
READ
REPLACE             
REPLACE NEXT 1      
REPLACE <scope beyond one >      
REPLACE RECORD <n>  Locks record <n>
SHOW GETS 

*Locks current record when editing begins
MODIFY MEMO
         
*Locks current record and all records from fields in related databases (specified by an alias) once the user begins editing a field
BROWSE 
CHANGE (without a format file)
EDIT (without a  format file)
             

*Locks database header
APPEND BLANK        
APPEND FROM ARRAY    
INSERT-SQL          


*Locks entire database
              
APPEND FROM         				
DELETE <scope scope beyond one>   
RECALL <scope beyond one>      
UPDATE
     
Regards,

Koen
Previous
Reply
Map
View

Click here to load this message in the networking platform