Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLExec Update and number of rows
Message
De
10/05/2016 02:28:07
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Divers
Thread ID:
01636071
Message ID:
01636077
Vues:
63
>Hi,
>
>When I execute an UPDATE command in the SSMS I see in the message areas of "so many rows affected". How can I get this number when executing the UPDATE from the VFP SQLExec() function? I tried adding a parameter, variable, to the SQLExec() hoping that it would return a cursor containing the number of affected rows. But it didn't work.
>Can it be done?
>TIA

Unless I misunderstand your question, the return value from SqlExec() is what you are looking for.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform