Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to retrieve the number of rows deleted
Message
 
 
To
18/07/2005 13:10:46
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 7
Miscellaneous
Thread ID:
01033589
Message ID:
01033595
Views:
20
This message has been marked as a message which has helped to the initial question of the thread.
If upgrade to VFP9 is an option, than
SQLEXEC( nConn, "DELETE FROM mytable WHERE mycondition", "Dummy", laCountInfo)
>I run
>
>
SQLEXEC( nConn, "DELETE FROM mytable WHERE mycondition")
>
>against Postgres SQL database
>and want to know how many rows this command deletes.
>
>sqlexec() does not return number of rows deleted, there is no SQLRowCount() function or access to ODBC result header from VFP. There is not @@RowCount like variable or function in Postgres.
>
<snip>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform