| Using the C1Query Control to Generate SQL > Generating SQL Statements |
To generate an SQL statement, call the BuildSQL method. It generates an SQL statement based on the information entered in the user query in C1QueryFrame controls attached to the C1Query control.
The BuildSQL method returns True if generation was successful. After successful generation, the generated SQL statement can be retrieved from the SQL property. Constituent clauses of the SQL statement can be retrieved from the properties ClauseSelect, ClauseFrom, ClauseWhere, ClauseOrderBy, and ClauseGroupBy.