Using the C1Query Control to Generate SQL > SQL Syntax Properties |
Properties governing syntax of the resulting SQL statement are assembled in a special SQLInfo object, C1Query.SQLInfo. These properties can be modified in code to tune SQL generation. They are mostly used to adjust to database-specific requirements, and there are also properties of general nature, such as Distinct, for example, used to modify the generated SQL.