ComponentOne Query 8.0
Database-Specific SQL Syntax

Syntax

Specifies the type of SQL syntax supported by the database, determining the syntax for outer and inner joins.

TableQuote

Quotation mark used to escape table names with blanks and special characters.

TableQuoteCriteria

Conditions under which a table name needs escaping (quoting).

FieldQuote

Quotation mark used to escape field names with blanks and special characters.

FieldQuoteCriteria

Conditions under which a field name needs escaping (quoting).

AddASToTableAlias

Whether to add the AS keyword before table alias.

StringLiteralQuote

Quotation mark used to enclose string literals.

DateTimeQuote

Quotation mark used to enclose date/time literals.

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback