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
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
To copy to clipboard, switch view to plain text mode
I execute procedury by:
query.prepare("{CALL ProcedureName2}");
query.exec();
QSqlQuery query;
query.prepare("{CALL ProcedureName2}");
query.exec();
To copy to clipboard, switch view to plain text mode
I cannot get reiserror message. I tried quert.lastError() but it return NoError
It`s any way to gets reiserror message?
Bookmarks