Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction behavior
Message
From
07/12/2005 15:15:53
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01075467
Message ID:
01075862
Views:
24
>>>>TABLEUPDATE(.T.) lock the table
>>>
>>>Any way to unlock it? Say, tablerevert right after tableupdate? Or use tableupdate in a loop for getnextmodified (?) [but I thought it should be done internally]
>>
>>1. You cannot do a tablerevert within a transaction.
>>
>
>You're right. My mistake.
>
>>If you have append records,
>>remember to set to 0 the bit 0 of the SET TABLEVALIDATE TO value.
>
>Can you elaborate on this idea, please?
>
>Thanks.

I check ( for a handful of seconds ) this:
* process 1
- use table with buffering=5
- update some records
- append some records
- begin trans
- tableupdate(all) && this lock the header 
* process 2
- IF BITTEST(SET("TableValidate"),0)
     use table && fire the table in use error
  ELSE
     use table && It is OK
  ENDIF
then try:
SET TABLEVALIDATE TO 0
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform