Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Transaction behavior
Message
De
07/12/2005 15:15:53
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01075467
Message ID:
01075862
Vues:
27
>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform