Board index » delphi » Retrieving error messages from SQL Server through ADO

Tim Karmiste

Delphi Developer
Tue, 01 Mar 2005 15:05:14 GMT

Retrieving error messages from SQL Server through ADO

I am writing a Delphi 6 application that uses a SQL 2000 database.
One of my stored procedures has PRINT statements which are shown to the user
during the execution of the procedure to inform them of any steps that they
need to take to further process the customer claim form..
Is there anyway to retrieve these PRINT messages from SQL Server once the
procedure has finished executing, and show them to the user inside the
Delphi application?

Regards,
    Tim Karmiste

 
Brian Bushay Team

Delphi Developer
Wed, 02 Mar 2005 06:37:04 GMT

Re:Retrieving error messages from SQL Server through ADO


Quote
>I am writing a Delphi 6 application that uses a SQL 2000 database.
>One of my stored procedures has PRINT statements which are shown to the user
>during the execution of the procedure to inform them of any steps that they
>need to take to further process the customer claim form..
>Is there anyway to retrieve these PRINT messages from SQL Server once the
>procedure has finished executing, and show them to the user inside the
>Delphi application?

If there is I do now know about it.  But what seems like the right way to do it
for me is to drop the Print statements and instead use return Parameters.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Herman Fr?ber

Delphi Developer
Thu, 10 Mar 2005 06:09:03 GMT

Re:Retrieving error messages from SQL Server through ADO


Have a look at

http://community.borland.com/article/0,1410,20245,00.html

maybe of some use.

Herman Fr?berg

Quote
"Tim Karmiste" <t...@specapps.com> wrote in message

news:3d818e2a$1@newsgroups.borland.com...
Quote
> I am writing a Delphi 6 application that uses a SQL 2000 database.
> One of my stored procedures has PRINT statements which are shown to the
user
> during the execution of the procedure to inform them of any steps that
they
> need to take to further process the customer claim form..
> Is there anyway to retrieve these PRINT messages from SQL Server once the
> procedure has finished executing, and show them to the user inside the
> Delphi application?

> Regards,
>     Tim Karmiste

Other Threads

1. ADO and retrieving MS SQL messages / PRINT statement text

2. Retrieve message from SQL Server using [eoExecuteNoRecords];

3. Retrieving PRINT messages from Sybase SQL Server

4. retrieving SQL Server info using ADO

5. Retrieving Advanced Error Information with SQL Server and Delphi 6

6. Trapping SQL Server Messages with ADO

7. Oracle error occourred, but error message could not be retrieved from Oracle

8. Retrieving Transact_SQL error message through ADO -> OLE DB -> SQL Server

9. ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000

10. Conflicting error message formats from SQL Server 2000