PDA

View Full Version : QSql + MsSql database: How can I get message from Reiserror()



esquer
20th February 2012, 21:59
I`ve got Ms SQL Database with stored procedure which ends ReiseError(...)



ALTER PROCEDURE [dbo].[ProcedureName2]

AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
----SET NOCOUNT ON;
DECLARE @Message varchar(1024);

set @Message='Some error';
RAISERROR (@Message, 20, 1)WITH SETERROR;
RETURN;
END


I execute procedury by:


QSqlQuery query;
query.prepare("{CALL ProcedureName2}");
query.exec();


I cannot get reiserror message. I tried quert.lastError() but it return NoError

It`s any way to gets reiserror message?