Page 1 of 1

View output of 'print' statements of StoredProcedures

Posted: Sun 14 Apr 2013 10:22
by medzoom
I am using TUniStoredProc for reading the results (even multiple resultssets) successfully of an executed StoredProcedure on an MSSQL 2008.

But I dont get it work, to read the "usual output of the sql-server / for example the print-statements of the StoredProcedure"?

I put some Print-Statements in the StoredProcedure on the sql-server and it would be nice to read via DELPHI also this information.

[code]
sql1.StoredProcName := 'sp_read_testtable';
sql1.SQL.Clear;
sql1.PrepareSQL;
sql1.ExecProc;
....

[/code]

I am using UniDAC 4.3.8 on Delphi 2007 /Win32

Does anyone know a workaround?

best regards

medzoom

Re: View output of 'print' statements of StoredProcedures

Posted: Mon 15 Apr 2013 09:50
by AndreyZ
Unfortunately, UniDAC doesn't have the functionality that allows obtaining the messages of the PRINT statements. For the time being, such functionality is available only in SDAC (using the OnInfoMessage event handler of the TMSConnection component).
We already have such request at our UserVoice page. You can vote for it here: http://devart.uservoice.com/forums/1046 ... connection. Suggestions with many votes will be implemented faster.

Re: View output of 'print' statements of StoredProcedures

Posted: Mon 15 Apr 2013 21:04
by medzoom
mercy for the answer!

medzoom

Re: View output of 'print' statements of StoredProcedures

Posted: Wed 17 Apr 2013 07:59
by AndreyZ
If you have any other questions about UniDAC, please contact us.