PN5_50481


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.