Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to determine if SQL Update successful?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01682800
Message ID:
01682816
Vues:
49
>>>How do I determine, in my PRG code, that a record has been updated? That is, without searching for the Field2 = 'XYZ'.
>>>
>>
>> Are you looking for absolute verification that indeed, the row was changed, and specifically, that the column was changed from 'ABC' to 'XYZ'?
>
>Yes.

In this case use OUTPUT clause of the update command (e.g. OUTPUT Deleted.Field, Inserted.Field and then examine the cursor.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform