ComponentOne Query 8.0
Overview
Product Profile
Feature List
Installing Query 8.0 for Active X
SetUp Files
System Requirements
Installing Demonstration Versions
Uninstalling
End-User License Agreement
Licensing FAQs
What is Licensing?
How does Licensing Work?
Technical Support
Redistributable Files
Adding ComponentOne Query 8.0 Control to a Visual Basic Project
Using ComponentOne ActiveX Controls in the .NET Framework
Getting Started
Product Components
C1Query Control
Schema Designer
C1Query Frame Control
C1QueryUI Control
Tutorials and Samples
Query 8.0 Samples
Tutorials
Tutorial 1 - Using C1Query in DataSource Mode
Tutorial 2 - Using C1Query Schema Designer
Tutorial 3 - Query Result Fields in C1QueryFrame Control
Tutorial 4 - C1Query Schema Features
Tutorial 5 - Using the Sample User Control C1QueryUI
Tutorial 6 - Customizing the User Interface with Templates
Tutorial 7 - Customizing the User Interface with Scripts
Tutorial 8 - Using C1Query Engine with Non-C1Query User Interface
Simple Queries - DataSource Mode
Easy Implementation of Simple Ad Hoc Query Functionality
Customizing the DataSourceFields Collection
Using the Schema Designer
Connecting to Database and Importing Database Structure
Views
Multi-Table Views
Join Groups
Folders
Field Lookup List
Relationships
Binary Join Relationships
Join Type
Two-Way Joins
Ternary and Higher Order Relationships
Condition Relationships
Extensions
Using the C1Query Control to Generate SQL
Generating SQL Statements
Errors in SQL Generation
Error Codes
Changing Query Items for the Duration of SQL Generation
Including/Excluding Query Items in the Resulting SQL
Database-Dependent Aspects of SQL Generation
SQL Syntax Properties
SQL Statement Features
Database-Specific SQL Syntax
Formatting Literal Values
Database Limitations on SQL
Managing Query Extensions
Developing a User Interface
C1QueryFrame Control
Using C1QueryFrame Properties, Methods and Events
General Appearance/Behavior Features
Item Navigation
Editing Values
Events on Changing a Query Item
Modifying Templates at Run Time
Handling Errors
Customizing the User Interface
Customizing the UI with Templates
Display style attributes
Message and Text Attributes
Menu attributes
Item Template Attributes
Comparison and Function Attributes
Special Tags
Tag Substitution Rules
Using Macros in Item Templates
Customizing the UI with Scripts
Script Attribute: RenderScript
Script Attribute: HtmlHead
Creating Your Own UI
Using C1Query on the Web
Maintaining, Saving and Restoring Queries
Modifying Schema and Field List at Run Time
Accessing and Modifying Query Items
Custom Editing and Lookup
Default Editing
Custom Editing
Modal Editing
Lookup Value Lists
Customizing Functions and Comparison Operators
Custom Functions
Custom comparison operators
Specifying Function and Comparison Attributes for a Particular Query Item
Type Checking in Condition Items
Object Reference
C1Query Object
C1QueryFrame Object
Field Object
Fields Object
QueryItem Object
SQLInfo Object
Property Reference
Quick Reference for All Properties
AddASToTableAlias Property
Advanced Property
Alias Property (Field)
Alias Property (QueryItem)
AllowExpressionInGroupBy Property
ApplyExtensions Property
BackColor Property
Border Property
Checkboxes Property
Checked Property (C1QueryFrame)
Checked Property (QueryItem)
ChildrenCount Property
ClauseFrom Property
ClauseGroupBy Property
ClauseOrderBy Property
ClauseSelect Property
ClauseWhere Property
Comparison Property
ComparisonAttributes Property
ComparisonTemplate Property
Complex Property
Connective Property
ContentsType Property
Count Property
CreateAliasForAggregatedField Property
CurrentElement Property
CurrentItemID Property
DataMember Property
DataSource Property
DataSourceFields Property
DataSourceName Property
DateTimeQuote Property
DebugContextMenu Property
DesignTimeTemplates Property
DisplayName Property
Distinct Property
EditedValue Property
EditedValueText Property
Editing Property
EditTypeChecking Property
Enabled Property
ErrorItemID Property
Exists Property
Expression Property
FieldQuote Property
FieldQuoteCriteria Property
FilterMode Property
Font Property (C1QueryFrame)
ForeColor Property
FormatBooleanFalse Property
FormatBooleanTrue Property
FormatDate Property
FormatDate Property (SQLInfo)
FormatFloat Property
FormatTime Property
FullFieldNames Property
FullFolderName Property
Function Property
FunctionAttributes Property
FunctionTemplate Property
HasChildren Property
HasLookup Property
HasNext Property
HasPrevious Property
IndexInParent Property
ID Property
Item Property (C1QueryFrame)
Item Property
LeftFieldID Property
LeftSide Property
LeftSideField Property
LeftSideKind Property
LeftSideValue Property
Level Property
LikePercent Property
LikeUnderscore Property
MainViewCount Property
MainViewName Property
MainViewNames Property
ManualRender Property
MaxNameLength Property
NameSubstitute Property
ParentID Property
PathSeparator Property
Precision Property
RightFieldID Property
RightSide Property
RightSideField Property
RightSideKind Property
RightSideValue Property
SaveSchemaAsString Property
Schema Property
SchemaControl Property
SchemaControlObject Property
Size Property
Sort Property
SQL Property
SQLInfo Property
StringLiteralQuote Property
Syntax Property
TabInQuery Property
TableName Property
TableQuote Property
TableQuoteCriteria Property
Tag Property (Field)
Tag Property (QueryItem)
TemplateAttributes Property
Templates Property
TemplateUserData Property
Type Property
TypedEditing Property
UseFieldAliasInGroupBy Property
UseFieldAliasInOrderBy Property
UseFieldAliasInWhere Property
UseIndexInOrderBy Property
UseNameAsFieldAlias Property
ViewFieldName Property
ViewName Property
Wrap Property
Event Reference
Quick Reference for All Events
AfterEdit Event
AfterMenu Event
AfterRender Event
BeforeEdit Event
BeforeMenu Event
BeforeSQLGeneration Event (C1Query)
BeforeSQLGeneration Event (C1QueryFrame)
Change Event
Click Event
DblClick Event
EndEdit Event
Error Event
FormatLiteral Event
HideCustomEditor Event
ItemFocusChange Event
KeyDown Event
KeyPress Event
KeyUp Event
LookupValues Event
ShowCustomEditor Event
MenuSelected Event
MouseDown Event
MouseMove Event
MouseUp Event
SQLGenerationItem Event
Method Reference
Quick Reference for All Methods
Add Method
AddItem Method
BuildSQL Method
Clear Method
DeleteItem Method
ExitEdit Method
FieldById Method
FieldNameToFieldID Method
FindByID Method
GenerateHTML Method
GetItemIDAt Method
LoadFromXML Method
LoadFromXMLFile Method
LoadSchemaFromFile Method
LoadTemplatesFromFile Method
MoveToChild Method
MoveToFirstChild Method
MoveToNext Method
MoveToPrevious Method
MoveToRoot Method
PerformMainMenuAction Method
Remove Method
Render Method
RetrieveFieldsFromDataSource Method
SaveToXML Method
SaveToXMLFile Method
ShowFolderFields Method
SetCurrentElement Method
SetLookup Method
SetTemplateAttribute Method
StartEdit Method
VarTypeFromDataType Method
WrapHTML Method