ComponentOne Query 8.0
Quick Reference for All Properties

AddASToTableAlias

Sets/returns the value that determines whether the AS keyword is to be used before table alias.

Advanced

Returns True if the item represents an advanced elementary condition.

Alias

The alias of a field in the generated SQL statement.

Alias

For a result field, sets/returns an alias to be used in the resulting SQL statement.

AllowExpressionInGroupBy

If True, calculated fields can be used in GROUP BY.

ApplyExtensions

Determines how schema extensions can be applied if necessary in SQL generation.

BackColor

Returns/sets the background color of the control.

Border

Returns/sets a value that determines whether the control has 3D border.

Checkboxes

If set to True, checkbox is displayed in query items, its state defining whether to include or ignore the item.

Checked

Determines whether to include or ignore the specified query item.

Checked

Determines whether to include or ignore the specified query item.

ChildrenCount

Returns the number of child items.

ClauseFrom

Returns the FROM clause of the last generated SQL statement.

ClauseGroupBy

Returns the GROUP BY clause of the last generated SQL statement.

ClauseOrderBy

Returns the ORDER BY clause of the last generated SQL statement.

ClauseSelect

Returns the SELECT clause of the last generated SQL statement.

ClauseWhere

Returns the WHERE clause of the last generated SQL statement, or the Filter text in data source mode.

Comparison

Returns/sets the comparison operation of an elementary condition item.

ComparisonAttributes

Comparison attributes of a query item.

ComparisonTemplate

Comparison template string of a query item.

Complex

Returns True if the item can contain other items.

Connective

Returns/sets the connective operation of a complex condition item.

ContentsType

Returns/sets the type of the control, whether it is used for specifying conditions or result fields.

Count

Returns the number of items in a collection.

CreateAliasForAggregatedField

If True, aliases are created for aggregated fields.

CurrentElement

Returns the element of an item which is currently selected (in focus) in that item.

CurrentItemID

Returns/sets the current (selected) item, its unique ID.

DataMember

Sets/returns the DataMember for the OLE DB DataSource.

DataSource

Specifies the source of schema information in data source mode.

DataSourceFields

Returns the collection of Field objects in data source mode.

DataSourceName

In data source mode, the name of a field in DataSource represented by this Field object.

DateTimeQuote

Sets/returns the quotation mark used with date/time literals.

DebugContextMenu

If True, the standard Internet Explorer context menu is used instead of the control's context menu at run time, for debug purposes.

DesignTimeTemplates

If set to False, template modification is ignored in control display at design time.

DisplayName

Returns/sets the display name of the field represented by a Field object.

Distinct

Sets/returns the value that determines whether the DISTINCT keyword must be added to the generated SQL statement.

EditedValue

Sets/returns the value of a constant being edited by a custom editor.

EditedValueText

Sets/returns the textual representation value of a constant being edited by a custom editor.

Editing

Returns a value indicating whether editing of a constant is in progress.

EditTypeChecking

Determines whether an error is raised when a constant value cannot be converted to the required type.

Enabled

Returns/sets a value that determines whether an object can respond to user-generated events.

ErrorItemID

Returns the unique ID of the item affected by an error condition.

Exists

In data source mode, indicates whether the field specified in DataSourceName exists in DataSource.

Expression

Returns/sets the expression for a calculated field.

FieldQuote

Sets/returns the quotation mark used to quote field names containing special characters.

FieldQuoteCriteria

Sets/returns the flags that determine when a field name must be quoted.

FilterMode

If True, the control is in Filter mode.

Font

Returns/sets the font used in the control.

ForeColor

Returns/sets the foreground color used in the control.

FormatBooleanFalse

Sets/returns the custom format for Boolean False value.

FormatBooleanTrue

Sets/returns the custom format for Boolean True value.

FormatDate

Formatting string for date values.

FormatDate

Sets/returns the custom format for date literals.

FormatFloat

Sets/returns the custom format for floating point literals.

FormatTime

Sets/returns the custom format for time literals.

FullFieldNames

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).

FullFolderName

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).

Function

Returns/sets the function of a result field query item.

FunctionAttributes

Function attributes of a result field query item.

FunctionTemplate

Function template string of a result field query item.

HasChildren

Returns the value indicating whether the item has children in the item tree.

HasLookup

Gets/sets whether the field has value list and whether LookupValues event should be fired for this field or not.

HasNext

Returns the value indicating whether the item has next sibling in the item tree.

HasPrevious

Returns the value indicating whether the item has previous sibling in the item tree.

ID

Returns the ID of a query item uniquely identifying it in the query tree.

IndexInParent

Returns the index of a query item in its parent.

Item

Returns a single collection item.

Item

Object providing access to individual items (conditions and result fields) of the control.

LeftFieldID

Returns/sets the unique schema ID for the field on the left side of a query item.

LeftSide

Returns/sets the textual representation of the left side of a query item.

LeftSideField

Returns/sets the Field object representing the left side of a query item.

LeftSideKind

Returns/sets the value that determines whether the left side of a query item is 'field' or 'constant'.

LeftSideValue

Returns/sets the value of the left side of a query item.

Level

Returns the level of a query item in the item tree.

LikePercent

Sets/returns the character to be used as wildcard matching zero or more characters.

LikeUnderscore

Sets/returns the character to be used as wildcard matching a single character.

MainViewCount

Returns the number of main views in the schema.

MainViewName

Returns/sets the name of the currently active schema main view.

MainViewNames

Returns the name of a main view from the collection of the schema main views.

ManualRender

If True, HTML rendering is performed by the C1QRender() function in the script defined in HTML Templates.

MaxNameLength

Sets/returns the maximum name length allowed in generated SQL statement.

NameSubstitute

Used as a substitute for the control's Name property in environments that don't support standard property such as Name or Id.

ParentID

Returns the parent ID of the a query item.

PathSeparator

Reads/Writes at run time and design time.

Precision

Precision of a numeric field.

RightFieldID

Returns/sets the unique schema ID for the field on the right side of a query item.

RightSide

Returns/sets the textual representation of the right side of a query item.

RightSideField

Returns/sets the Field object representing the right side of a query item.

RightSideKind

Returns/sets the value that determines whether the left side of a query item is 'field' or 'constant'.

RightSideValue

Returns/sets the value of the right side of a query item.

SaveSchemaAsString

If True, schema is saved as string instead of byte array.

Schema

Returns/sets the control's schema as a string.

SchemaControl

Returns/sets the name of the C1Query control containing the schema and performing SQL generation.

SchemaControlObject

Returns/sets (at run time) the C1Query control containing the schema and performing SQL generation.

Size

Field's maximum data size.

Sort

Returns/sets the sort of a result field query item.

SQL

Returns the SQL statement generated by the last BuildSQL call.

SQLInfo

Object used for customizing SQL syntax settings and parameters.

StringLiteralQuote

Sets/returns the quotation mark used with string literals.

Syntax

Sets/returns the value that determines the join syntax in generated SQL statement.

TabInQuery

If True, the Tab key navigates between the control's items rather than between different controls.

TableName

The table name of a view field represented by this Field object.

TableQuote

Sets/returns the quotation mark used to quote table names containing special characters.

TableQuoteCriteria

Sets/returns the flags that determine when a table name must be quoted.

Tag

Stores arbitrary additional information for the field.

Tag

Stores arbitrary additional information associated with the query item.

TemplateAttributes

Returns/sets the template attribute with specified name.

Templates

Returns/sets the string modifying HTML templates defining control's look and UI.

TemplateUserData

Custom template parameters.

Type

Field's data type.

TypedEditing

If set to True, the control uses special editors for data types such as date/time, Boolean, numeric.

UseFieldAliasInGroupBy

If True, calculated field's name or alias is used in GROUP BY, instead of the expression.

UseFieldAliasInOrderBy

If True, calculated field's name or alias is used in ORDER BY, instead of the expression.

UseFieldAliasInWhere

If True, calculated field's name or alias is used in WHERE, instead of the expression.

UseIndexInOrderBy

If True, column index is used in ORDER BY instead of column name.

UseNameAsFieldAlias

If True, a folder field's Name is used as the field's alias.

ViewFieldName

The name of a view field represented by this Field object, or the name of a DataSourceFields field in data source mode.

ViewName

The view name of a view field represented by this Field object.

Wrap

Enables/disables wordwrap in the control. Used in C1QRender() script with ManualRender=True.

See Also

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Product Support Forum  |  Documentation Feedback