SQLInfo Object

SQLInfo Object Properties

AddASToTableAlias	Sets/returns the value that determines whether the AS keyword is to be used before table alias.
AllowExpressionInGroupBy	If True, calculated fields can be used in GROUP BY.
CreateAliasForAggregatedField	If True, aliases are created for aggregated fields.
DateTimeQuote	Sets/returns the quotation mark used with date/time literals.
Distinct	Sets/returns the value that determines whether the DISTINCT keyword must be added to the generated SQL statement.
FieldQuote	Sets/returns the quotation mark used to quote field names containing special characters.
FieldQuoteCriteria	Sets/returns the flags that determine when a field name must be quoted.
FormatBooleanFalse	Sets/returns the custom format for Boolean False value.
FormatBooleanTrue	Sets/returns the custom format for Boolean True value.
FormatDate	Sets/returns the custom format for date literals
FormatFloat	Sets/returns the custom format for floating point literals.
FormatTime	Sets/returns the custom format for time literals.
LikePercent	Sets/returns the character to be used as wildcard matching zero or more characters.
LikeUnderscore	Sets/returns the character to be used as wildcard matching a single character.
MaxNameLength	Sets/returns the maximum name length allowed in generated SQL statement.
StringLiteralQuote	Sets/returns the quotation mark used with string literals.
Syntax	Sets/returns the value that determines the join syntax in generated SQL statement.
TableQuote	Sets/returns the quotation mark used to quote table names containing special characters.
TableQuoteCriteria	Sets/returns the flags that determine when a table name must be quoted.
UseFieldAliasInGroupBy	If True, calculated field's name or alias is used in GROUP BY, instead of the expression.
UseFieldAliasInOrderBy	If True, calculated field's name or alias is used in ORDER BY, instead of the expression.
UseFieldAliasInWhere	If True, calculated field's name or alias is used in WHERE, instead of the expression.
UseIndexInOrderBy	If True, column index is used in ORDER BY instead of column name.
UseNameAsFieldAlias	If True, a folder field's Name is used as the field's alias.