Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Triggers and Locks
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Triggers and Locks
Divers
Thread ID:
00863867
Message ID:
00863867
Vues:
47
Hi... I wish a great year for all of you!

So, my year started a little bit complicated! ;-)

I have one table and I created one trigger for it. When one record is deleted, the trigger is fired. This function returns always .F. (it is just for tests)
* Situation 1
USE Customers
LOCATE FOR CustomerId = 100
DELETE
In this case, all works fine. When I try to DELETE the record, VFP returns an error message! Great! :-)
* Situation 2
USE Customers
LOCATE FOR CustomerId = 100
? RLOCK() && It returns .T.
DELETE
INKEY(0)
UNLOCK
In this situation, I just receive an error message after VFP runs UNLOCK... My problem is part of my solution is encapsulated in some class (Lock and Unlock records) and the other part (DELETE) doesn't... And I have to know If some error has occured when VFP DELETE the record...

Any suggestion?

[]s!
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform