Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to lock a record While using remote views (ODBC)
Message
De
19/07/2002 10:25:39
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
17/07/2002 11:34:36
Raza Malik
Universal Accounting Software
Edgewater, New Jersey, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00679641
Message ID:
00680444
Vues:
21
>I am using VFP7. I am very heavy on remote views for table updating. Is
>there a way to lock a row/record (such as customer record while entering sales orders).
>
>Sincerely,
>
>Raz

I don't know whether it is possible - I think not, but I am not sure. However, the usual way to handle views is to attempt a TableUpdate(). If another user modified the information in the meantime, TableUpdate() will fail (this depends on the options specified - read the help), and return .F. In this case, your program will revert changes, and the user has to type the information again.

HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform