Something you might try is to use PRINT instead
of RAISERROR. (I appreciate that it's
uglier - just as a test).
They're supposed to be handled equivalently
when severity is <=10.
ns
-----Original Message-----
From: Neil <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Friday, 25 August 2000 10:04
Subject: [DUG]: Raiserror, SQL and ADO
Hi All
I have a long stored procedure which updates several tables and
I want to monitor its progress.
In the stored procedure I am using several Raiserror commands
each with a severity of 10.
To run the stored procedure I use TADOConnection and TADOCommand
objects and I am trying to capture the Raiserror output in the
OnInfoMessage event of the TADOConnection component (I have set
the ADOCommand.eoExecuteNoRecords = true).
With this set up I am only capturing output from the first
Raiserror command.
Any ideas why this is happening?
I am using MDAC 2.5/Delphi5
Thanks Neil
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
