<< Click to Display Table of Contents >> Navigation:  Apollo VCL Components > Installing and Using Apollo VCL > Apollo SQL Notes

Creation of conditional indexes are not currently supported via TApolloQuery.SQL, but can be created through TApolloTable's Index and IndexTag methods (for Apollo VCL users).

TQuery differences:

•Calculated fields in the result set not fully supported. As a solution, you can create calculated columns by defining them in the list of columns in SELECT clause of SQL statement.

•Dates are defined as follows: #mm/dd/yyyy#

•Long names (also called extended identifiers), for fields and table names are managed using this notation:

[This Is a long Name]

 

compared to TQuery

"This is a long name".