DB Setting

This version adds a setting to control the construction of Database queries. Specifically, it allows the admin to specify how SQL queries will identify column names. This is a setting that is necessary because some databases (MySQL) do not follow the SQL standard for identifier delimiters.

For example, if a DB table has a column named PRICE then it would be written as

if the delimiter identifier is double-quote or

if the delimiter is back-quote.

The default is to use a double-quote. You will not need to change this setting unless you are using a DB that does not use the standard delimiter. If you are using MySQL database then change this setting to back-quote.

Open

https://appfire.atlassian.net/wiki/spaces/SUP/pages/147360382

https://appfire.atlassian.net/wiki/spaces/SUP/pages/147358680