Microsoft KB Archive/71164

PRB: Rows Affected by INSERTS/UPDATES Not Shown in SAF ID Number: Q71164

1.10 1.11 4.20 OS/2

Summary:

SYMPTOMS After doing an INSERT or UPDATE statement through SAF, the number of rows affected by the insert or update is not displayed. Running the same INSERT or UPDATE statements through ISQL displays the message “(xx rows affected)”.

RESOLUTION You can obtain the number of rows from SAF in either of two ways:

  After performing an INSERT or UPDATE statement through SAF, select the global variable @@rowcount to determine the number of rows affected.   Create a stored procedure on SQL Server that performs the insert or update and sends confirmation back to SAF as a result row generated by a SELECT statement. For an example of a stored procedure with this functionality, query on the following words: SQL Server and DDE and confirmation Note: In SQL Server version 4.2, SAF displays the number of rows affected by an INSERT, UPDATE, or DELETE statement. 