Patch Number |
Ticket Number |
Change type |
5_50481 |
752239 |
Patch |
1. Description
Expand current error message so that it gives a better clue to what went wrong.
2. Previous Release Behavior
SQLSELECT * FROM PW_STOCK_TOTALS You would get an error saying… SQLSELECT * FROM PW_STOCREK_TOTALS Error in Statement "SELECT * FROM PW_STOCK_TOTALS" Parse Error: WMS_DATE.
In this example the actual error was caused by a column being called [DATE]. (reserved word) [WMS_DATE] just so happens to be the last valid column processed before the error, this was a little confusing as if you check the column there is no issues.
3. Current Release Behavior
SQLSELECT * FROM PW_STOCK_TOTALS Error in Statement "SELECT * FROM PW_STOCK_TOTALS" Parse Error: An internal error occurred, jSQL was unable to determine how to process the current command following [NOTAV_HOST] at position [28] please review. Last statement executed [SELECT PROD_NO,AVAIL_HOST,NOTAV_HOST,DATE,... FROM PW_STOCK_TOTALS].
Which should now give the position within the SQL statement and what it was trying to execute, hopefully making it easier to spot what just went wrong.