Error Handling - MS SQL SERVER - Including Error Line Number in MyDBR Response

(3 posts) (2 voices)


No tags yet.

  1. jdluth, Member

    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.

  2. 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

  3. jdluth, Member

    Well that sure bites. Thanks for the consideration and explanation.


You must log in to post.