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