🚀 go-pugleaf

I have tried an idea from another post that involved the use of
SET NOCOUNT ON to disable a notification to the ADO about the
number of records that were updated. The SET NOCOUNT ON is
allowing the ADO to work correctly.

"David Senterfitt" <senterfd@gordon.army.mil> wrote:
>
>I have just started receiving the error message. I have been
>reading the other posts accross this site and tried many of the
>suggestions. None of them have worked so I needed to post my
>situation. Here it is.
>
>I am running MS SqlServer 2000 using the ADO library within my
>C++ Builder App.
>
>I have a stored procedure that returns a single record dataset
>that has been created from a SELECT with several JOIN clauses.
>
>I have an update trigger inside the database that updates a
>table used for tracking.
>
>If I disable the trigger then everything works correctly. I looked
>for errors in the trigger. There are no errors.
>
>Here is what I feel is happening. The ADO layer comunicates to
>the database that it needs to update 1 record. The database
>updates 1 record in the initial table.  The update trigger modifies 6 records accordingly. The database responds to the ADO
>layer that it modified 6 records. The ADO layer performs an
>error check and notifies the user with the error message.
>
>Does anybody have any ideas?
>
>Thank you,
>David Senterfitt