Hi,
I am also using MDAC 2.5/Delphi 5 to a SQL Server 7.0 database, all within
Win98. I have had problems with raising errors in the past although my
problems are probably completely unrelated to yours.
If I used RaiseError as one of the first commands in the Stored Proc then it
worked fine. However if I used RaiseError after a successful update command
then the error didn't cause an exception in Delphi. From memory the errors
did appear in the TADOCommand.Errors property but they may not have
triggered OnInfoMessage.
I reported this to Borland Tech Support and they were unable to replicate
the error on a similar configuration. This implies that the problem is with
my setup (entirely possible, my Win98 installs tend to disintegrate fairly
rapidly ;-). It's not a major problem for me so I have put it on hold in the
hopes that it will go away.
I think there might be some bugs in the way Delphi 5 (and/or MDAC) reports
raiserrors. If you have any success at shedding light on the problems then
please do tell!
David.
-----Original Message-----
From: Neil <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Date: Friday, 25 August 2000 15:01
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
