| Object Reference > C1Query Object |
|
Determines how schema extensions can be applied if necessary in SQL generation. |
|
|
Returns the FROM clause of the last generated SQL statement. |
|
|
Returns the GROUP BY clause of the last generated SQL statement. |
|
|
Returns the ORDER BY clause of the last generated SQL statement. |
|
|
Returns the SELECT clause of the last generated SQL statement. |
|
|
Returns the WHERE clause of the last generated SQL statement, or the Filter text in data source mode. |
|
|
Sets/returns the DataMember for the OLE DB DataSource. |
|
|
Specifies the source of schema information in data source mode. |
|
|
Returns the collection of Field objects in data source mode. |
|
|
If True, the control is in Filter mode. |
|
|
Returns the number of main views in the schema. |
|
|
Returns/sets the name of the currently active schema main view. |
|
|
Returns the name of a main view from the collection of the schema main views. |
|
|
Used as a substitute for the control's Name property in environments that do not support standard property such as Name or Id. |
|
|
If True, schema is saved as string instead of byte array. |
|
|
Returns/sets the control's schema as a string. |
|
|
Returns the SQL statement generated by the last BuildSQL call. |
|
|
Object used for customizing SQL syntax settings and parameters. |
|
|
Returns/sets the string modifying HTML templates in C1QueryFrame controls attached to the control, defining their look and UI. |
|
Builds SQL statement. |
|
|
Loads the schema from a file to the control. |
|
|
Retrieves the field list from DataSource to the Fields collection, in data source mode. |
|
|
Shows or hides folders/fields in schema and field menu. |
|
Occurs before SQL generation and allows the user to change query items and syntax rules affecting resulting SQL. |
|
|
Occurs as a result of an error condition. |
|
|
Occurs before inserting a literal value in SQL statement. |