Object Reference > SQLInfo Object |
Sets/returns the value that determines whether the AS keyword is to be used before table alias. |
|
If True, calculated fields can be used in GROUP BY. |
|
If True, aliases are created for aggregated fields. |
|
Sets/returns the quotation mark used with date/time literals. |
|
Sets/returns the value that determines whether the DISTINCT keyword must be added to the generated SQL statement. |
|
Sets/returns the quotation mark used to quote field names containing special characters. |
|
Sets/returns the flags that determine when a field name must be quoted. |
|
Sets/returns the custom format for Boolean False value. |
|
Sets/returns the custom format for Boolean True value. |
|
Sets/returns the custom format for date literals |
|
Sets/returns the custom format for floating point literals. |
|
Sets/returns the custom format for time literals. |
|
Sets/returns the character to be used as wildcard matching zero or more characters. |
|
Sets/returns the character to be used as wildcard matching a single character. |
|
Sets/returns the maximum name length allowed in generated SQL statement. |
|
Sets/returns the quotation mark used with string literals. |
|
Sets/returns the value that determines the join syntax in generated SQL statement. |
|
Sets/returns the quotation mark used to quote table names containing special characters. |
|
Sets/returns the flags that determine when a table name must be quoted. |
|
If True, calculated field's name or alias is used in GROUP BY, instead of the expression. |
|
If True, calculated field's name or alias is used in ORDER BY, instead of the expression. |
|
If True, calculated field's name or alias is used in WHERE, instead of the expression. |
|
If True, column index is used in ORDER BY instead of column name. |
|
If True, a folder field's Name is used as the field's alias. |