Re: trigger causes exception

From: "Kevin Frevert" <kevin@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 27 Oct 2005 21:31:25 -0500

"Brad White" <bwhite at inebraska.com> wrote in message
news:43614488$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Using D2005,
> ClientDataSets and ADO,
> SQL Server 2000, version 8.00.760
>
> Sporadically we will get an exception in ApplyUpdates:
> "record not found or changed by another user"

Add this to the beginning of your trigger...

SET NOCOUNT ON

The 'rows affected' message being returned is 'confusing' ADO.

Good luck,
krf

.

References:
- trigger causes exception
  - From: Brad White

Prev by Date: Re: Recovering from an updatebatch error with a clone
Next by Date: Re: In-Memory Dataset
Previous by thread: Re: "record not found or changed by another user"
Next by thread: Recovering from an updatebatch error with a clone
Index(es):
- Date
- Thread

Relevant Pages

Re: ADO.NET Not Returning Error
... > a catch (Exception e) so the error should be captured if there is one. ... > but I get nothing back from ADO for this statement. ... > queries and when a user types in a query of this format, ...
(microsoft.public.dotnet.framework.adonet)
D7 & ADO with ASA9: EOLEException & Multiple-step error
... If I rest my pointer over the ".AsString" part of AdoDataMod.aquGetClipReadOnly.FieldByName.AsString, I get the yellow ribbon hint with the text "Delphi Exception EoleException at ... I tried removing the fields from the ADO query, I tried adding them back in again, I tried closing everything and rebooting - so far so bad... ... The BDE version has been working with identical data for nearly 10 years without a hitch - it still is. ...
(borland.public.delphi.database.ado)
Re: Problems using ADO with multi threading
... ListIndexOutOfBounds is VCL (not MS ADO) exception, ... create new data module instance for every thread. ...
(borland.public.delphi.database.ado)
Re: ADO.NET Not Returning Error
... > a catch (Exception e) so the error should be captured if there is one. ... > also get other info messages, ... > but I get nothing back from ADO for this statement. ... > queries and when a user types in a query of this format, ...
(microsoft.public.dotnet.framework.adonet)
Re: ADO.NET Not Returning Error
... a catch (Exception e) so the error should be captured if there is one. ... also get other info messages, ... but I get nothing back from ADO for this statement. ... queries and when a user types in a query of this format, ...
(microsoft.public.dotnet.framework.adonet)