>Can you give me an example, I am not sure how to use it.
>

nConn = SQLCOnnect( 'MyDataBase' )

SQLExec( nConn, [UPDATE MyTable SET MyField = 'NewValue' WHERE ID='1'] )
SQLExec( nConn, [Select @@ROWCOUNT as nCount], 'curResult' )

Wait Window curResult.nCount + " Records Updated!"

***********
something like that, I may have a syntax above wrong.

BOb


>Thanks Chris
>
>
>No... @@ROWCOUNT contains the number of records affected by the last command sent on that connection. You can also use @@ROWCOUNT to see if a record was updated too.
>
>>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