• 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