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: 1. also use backticks for the index names, 2. removed the incorrect backticks in the INSERT statements.
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:
1. also use backticks for the index names,
2. removed the incorrect backticks in the INSERT statements.