Getting feedback from scripts

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
bernr
Posts: 17
Joined: Fri 14 Dec 2007 22:07

Getting feedback from scripts

Post by bernr » Thu 20 Mar 2008 01:09

I have a 9000 line T-SQL script that has print statements in it to give status of what it is doing, is there a way I can be able to see these using any of the SDAC Controls? I am currently using the MSScript control to execute the script.

Thanks Bern
Top
Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 20 Mar 2008 07:51

You should handle the OnInfoMessage event of the linked TMSConnection. Also add the OLEDBAccess unit to the uses clause.
Last edited by Antaeus on Thu 20 Mar 2008 07:52, edited 1 time in total.
Top
bernr
Posts: 17
Joined: Fri 14 Dec 2007 22:07

Post by bernr » Thu 20 Mar 2008 10:42

Thank you for your reply, I have added the OnInfoMessage event to my TMSConnection but it does not seem to be firing. Any suggestions?
Top
Post Reply

Return to “SQL Server Data Access Components”