Property Reference > Quick Reference for All Properties |
Sets/returns the value that determines whether the AS keyword is to be used before table alias. |
|
Returns True if the item represents an advanced elementary condition. |
|
The alias of a field in the generated SQL statement. |
|
For a result field, sets/returns an alias to be used in the resulting SQL statement. |
|
If True, calculated fields can be used in GROUP BY. |
|
Determines how schema extensions can be applied if necessary in SQL generation. |
|
Returns/sets the background color of the control. |
|
Returns/sets a value that determines whether the control has 3D border. |
|
If set to True, checkbox is displayed in query items, its state defining whether to include or ignore the item. |
|
Determines whether to include or ignore the specified query item. |
|
Determines whether to include or ignore the specified query item. |
|
Returns the number of child items. |
|
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. |
|
Returns/sets the comparison operation of an elementary condition item. |
|
Comparison attributes of a query item. |
|
Comparison template string of a query item. |
|
Returns True if the item can contain other items. |
|
Returns/sets the connective operation of a complex condition item. |
|
Returns/sets the type of the control, whether it is used for specifying conditions or result fields. |
|
Returns the number of items in a collection. |
|
If True, aliases are created for aggregated fields. |
|
Returns the element of an item which is currently selected (in focus) in that item. |
|
Returns/sets the current (selected) item, its unique ID. |
|
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. |
|
In data source mode, the name of a field in DataSource represented by this Field object. |
|
Sets/returns the quotation mark used with date/time literals. |
|
If True, the standard Internet Explorer context menu is used instead of the control's context menu at run time, for debug purposes. |
|
If set to False, template modification is ignored in control display at design time. |
|
Returns/sets the display name of the field represented by a Field object. |
|
Sets/returns the value that determines whether the DISTINCT keyword must be added to the generated SQL statement. |
|
Sets/returns the value of a constant being edited by a custom editor. |
|
Sets/returns the textual representation value of a constant being edited by a custom editor. |
|
Returns a value indicating whether editing of a constant is in progress. |
|
Determines whether an error is raised when a constant value cannot be converted to the required type. |
|
Returns/sets a value that determines whether an object can respond to user-generated events. |
|
Returns the unique ID of the item affected by an error condition. |
|
In data source mode, indicates whether the field specified in DataSourceName exists in DataSource. |
|
Returns/sets the expression for a calculated field. |
|
Sets/returns the quotation mark used to quote field names containing special characters. |
|
Sets/returns the flags that determine when a field name must be quoted. |
|
If True, the control is in Filter mode. |
|
Returns/sets the font used in the control. |
|
Returns/sets the foreground color used in the control. |
|
Sets/returns the custom format for Boolean False value. |
|
Sets/returns the custom format for Boolean True value. |
|
Formatting string for date values. |
|
Sets/returns the custom format for date literals. |
|
Sets/returns the custom format for floating point literals. |
|
Sets/returns the custom format for time literals. |
|
If True, the control shows full dot-separated field names containing folder names. (C1Query.PathSeparator is used instead of dot, if set by the programmer). |
|
Full dot-separated folder name of a field represented by this Field object. (C1Query.PathSeparator is used instead of dot, if set by the programmer). |
|
Returns/sets the function of a result field query item. |
|
Function attributes of a result field query item. |
|
Function template string of a result field query item. |
|
Returns the value indicating whether the item has children in the item tree. |
|
Gets/sets whether the field has value list and whether LookupValues event should be fired for this field or not. |
|
Returns the value indicating whether the item has next sibling in the item tree. |
|
Returns the value indicating whether the item has previous sibling in the item tree. |
|
Returns the ID of a query item uniquely identifying it in the query tree. |
|
Returns the index of a query item in its parent. |
|
Returns a single collection item. |
|
Object providing access to individual items (conditions and result fields) of the control. |
|
Returns/sets the unique schema ID for the field on the left side of a query item. |
|
Returns/sets the textual representation of the left side of a query item. |
|
Returns/sets the Field object representing the left side of a query item. |
|
Returns/sets the value that determines whether the left side of a query item is 'field' or 'constant'. |
|
Returns/sets the value of the left side of a query item. |
|
Returns the level of a query item in the item tree. |
|
Sets/returns the character to be used as wildcard matching zero or more characters. |
|
Sets/returns the character to be used as wildcard matching a single character. |
|
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. |
|
If True, HTML rendering is performed by the C1QRender() function in the script defined in HTML Templates. |
|
Sets/returns the maximum name length allowed in generated SQL statement. |
|
Used as a substitute for the control's Name property in environments that don't support standard property such as Name or Id. |
|
Returns the parent ID of the a query item. |
|
Reads/Writes at run time and design time. |
|
Precision of a numeric field. |
|
Returns/sets the unique schema ID for the field on the right side of a query item. |
|
Returns/sets the textual representation of the right side of a query item. |
|
Returns/sets the Field object representing the right side of a query item. |
|
Returns/sets the value that determines whether the left side of a query item is 'field' or 'constant'. |
|
Returns/sets the value of the right side of a query item. |
|
If True, schema is saved as string instead of byte array. |
|
Returns/sets the control's schema as a string. |
|
Returns/sets the name of the C1Query control containing the schema and performing SQL generation. |
|
Returns/sets (at run time) the C1Query control containing the schema and performing SQL generation. |
|
Field's maximum data size. |
|
Returns/sets the sort of a result field query item. |
|
Returns the SQL statement generated by the last BuildSQL call. |
|
Object used for customizing SQL syntax settings and parameters. |
|
Sets/returns the quotation mark used with string literals. |
|
Sets/returns the value that determines the join syntax in generated SQL statement. |
|
If True, the Tab key navigates between the control's items rather than between different controls. |
|
The table name of a view field represented by this Field object. |
|
Sets/returns the quotation mark used to quote table names containing special characters. |
|
Sets/returns the flags that determine when a table name must be quoted. |
|
Stores arbitrary additional information for the field. |
|
Stores arbitrary additional information associated with the query item. |
|
Returns/sets the template attribute with specified name. |
|
Returns/sets the string modifying HTML templates defining control's look and UI. |
|
Custom template parameters. |
|
Field's data type. |
|
If set to True, the control uses special editors for data types such as date/time, Boolean, numeric. |
|
If True, calculated field's name or alias is used in GROUP BY, instead of the expression. |
|
If True, calculated field's name or alias is used in ORDER BY, instead of the expression. |
|
If True, calculated field's name or alias is used in WHERE, instead of the expression. |
|
If True, column index is used in ORDER BY instead of column name. |
|
If True, a folder field's Name is used as the field's alias. |
|
The name of a view field represented by this Field object, or the name of a DataSourceFields field in data source mode. |
|
The view name of a view field represented by this Field object. |
|
Enables/disables wordwrap in the control. Used in C1QRender() script with ManualRender=True. |