Bob,

So, what your saying is count the number of records prior to the insert, then count them after? Do you know anything about sqlcommit()? At first glance, this looks like it is what I need.

Thanks, Chris

>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