Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Locking records using Select-Sql
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00649340
Message ID:
00649377
Vues:
11
Hi folks! (again)!

I've found() the solution myself! See below:
* For lock:
Select RecNo() As Registro, RLock() As Trava From Tabela Where Codigo = 1 Into Cursor Resultado
If Resultado.Trava = .F.
   MessageBox("Record in use for another user")
   Return .F.
EndIf
* For UnLock:
UnLock Record Resultado.Registro In Tabela
And that is all! :) - Someone can see anything wrong in this code?

[]s
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform