SyntaxFromSQL execution error

The application crashes when executing the same SQL statement via SyntaxFromSQL.

Debugging technique:

We shall first check the web debugging proxy tool, such as Fiddler, to locate at what operation the error occurred (at the execution of SyntaxFromSQL), and also find out the error message captured. Check in the Inspector TextView for the possible causes:

  • Is there SqlErrorText?

  • Is any column name empty? --- Check the columnname;

  • Any improper date type? --- Check the datatype;

  • Issue with the column length or precision?

Then you will see there is a null column name. After setting an alias to the null column, SyntaxFromSQL can then be executed successfully:

Column in the SQL: birthday + interval '10 day'
Add an alias to the column: birthday + interval '10 day' rq