Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How many records affected
Message
 
 
À
04/01/2006 16:12:23
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexique
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Oracle
Divers
Thread ID:
01083315
Message ID:
01083319
Vues:
10
>How can I retrieve the number of records affected by an INSERT, UPDATE or DELETE operation against an Oracle database?
>
>With SELECT there's no problem since all I need is the _tally variable or the reccount() of the resulting cursor but with the other operations?

You cannot rely on _TALLY for SPT access. It's not updated by SQLEXEC().
The SQLEXEC() function has new 4th parameter aCountInfo specificly to get back the # of affected records.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform