Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How many records affected
Message
 
 
To
04/01/2006 16:12:23
Héctor Lizarraga
Gobierno Del Edo de Querétaro
Querétaro, Mexico
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Oracle
Miscellaneous
Thread ID:
01083315
Message ID:
01083319
Views:
11
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform