Good day! When I'm working in the report builder, when I have a coding mistake I receive the relevant error message after attempting to execute the modified procedure, however, I do not receive back the line number for that error. For MSSQL, this is part of the standard error message and would make it much easier for trouble shooting when attempting to find where a missing comma or misspelled column name is.
Error Handling - MS SQL SERVER - Including Error Line Number in MyDBR Response
(3 posts) (2 voices)-
jdluth, Member
-
myDBR Team, Key Master
We would like to return the line number of the error. Unfortunately the mssql-driver returns the line number of the PHP code making the call (not the line number of the SQL code) and the sqlsrv-driver does not return the line number at all, so at this time that information is not available.
--
myDBR Team -
jdluth, Member
Well that sure bites. Thanks for the consideration and explanation.
Reply
You must log in to post.