Hello,
I have created a patch which adds backticks round the SQL table and field names, to prevent syntax errors when reserved keywords are used.
It has been tested with sqlite version 3.5.9
nick.
patch to add backticks round sql
Improved version of Nicholas' backticks patch when using the SQL output --sql option of pxview. Changes with respect to the original patch:
Log in to post a comment.
patch to add backticks round sql
Improved version of Nicholas' backticks patch when using the SQL output --sql option of pxview. Changes with respect to the original patch: