I run an update statement and use a db.execute (updatestatementstring) code. How Can i check to see if it did an update? I know in Visual Basic you can run a nonquery and it will return how many records it updated etc.
Use the RecordsAffected property of the Connection, Database, or QueryDef object to determine the number of records affected by the most recent Execute method. For example, RecordsAffected contains the number of records deleted, updated, or inserted when executing an action query. When you use the Execute method to run a query, the RecordsAffected property of the QueryDef object is set to the number of records affected.