General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I would like to know the best way to verify if data inserted into a client/server table was committed. I establish a connection and verify the connection. Then, I intert data into the table. This all work fine, I just need to verify the insert.
>
>Thanks, Chris
Select @@ROWCOUNT on the same connection you did your insert. If it returns a number equal to the rows you expected your insert worked.
SQLExec just returning an OK, doesn't mean the Update actually modified any rows, it just means there were no syntax or comunication errors.
BOb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only