Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL-Update Without _Tally?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00743634
Message ID:
00743744
Views:
11
I am running a SQL-Update over OLEDB, and the _tally variable is not available. Can anyone recommend a way to tell if an Update / Set has been successful other than following the Update with a SQL-Select?

Steve,

If you're using SQL Server, you can always send the "SELECT @@ROWCOUNT" statement to the server after the update and that should give you the number of rows affected by the previous statement. If you're using a different back end then I don't know if @@ROWCOUNT would work - if it doesn't then there should be something comparable.

Laterness,
Jon
Jon Rosenbaum
Devcon Drummer
Previous
Reply
Map
View

Click here to load this message in the networking platform