Feature request #10612

MSSQL - Show user defined error messages

Added by Jan Lippmann over 5 years ago. Updated over 1 year ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Data Provider/MSSQL
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:19016

Description

hello,

it would be useful, if qgis could show the user defined error messages (from the mssql server backend) in the qgis messagebar details.
now are this errors/messages not visible in the messagebar while editing for instance...

MSSQL example for user defined error:

RAISERROR (N'This is my errorstring.', -- Message text.
           18, -- Severity,
           1  -- State
);

under the postgres dataprovider it works with this defined error/exception, qgis show the 'This is my errorstring.' in the messagebar details.

RAISE EXCEPTION 'This is my errorstring.'

thanks
jan

History

#1 Updated by Jürgen Fischer over 5 years ago

  • Assignee deleted (Jürgen Fischer)
  • Category changed from Data Provider to Data Provider/MSSQL

#2 Updated by Jürgen Fischer over 5 years ago

  • Target version changed from Version 2.4 to Future Release - High Priority

#3 Updated by Giovanni Manghi over 2 years ago

  • Easy fix? set to No

#4 Updated by Jan Lippmann over 1 year ago

  • Status changed from Open to Closed

Now it works with qgis 3.2.

Also available in: Atom PDF