• ComponentOne True DataControl 8.0
  • Overview
  • Product Profile
  • Feature List
  • True DataControl Lite
  • Installing True DataControl 8.0 for Active X
    • Installing Demonstration Versions
    • Uninstalling Demonstration Versions
  • Upgrading From Previous Versions
  • End-User License Agreement
  • Licensing FAQs
    • What is Licensing?
    • How does Licensing Work?
  • Technical Support
  • Redistributable Files
  • Adding True DataControl 8 to a Visual Basic Project
  • Using ComponentOne ActiveX Controls in the .NET Framework
  • Using True DataControl as Your Data Source
    • Binding Your Controls to True DataControl
    • Using the Recordset Property
    • Using Recordset Events
  • Using True DataControl Lite
    • Binding TDataLite to a Data Source
    • Binding Data-Aware Controls and TDataLite to the Same Standard Data Source
    • Binding Data-Aware Controls to a TDataLite Control
  • Improvements Over Standard ADO Data Sources
    • Performance on Large Recordsets
    • Fixing Problems with adUseServer
    • Microsoft Access Problem with Refreshing Recordsets from Database
    • Reused (pooled) Connections
• True DataControl Samples
• Tutorials - True DataControl
  • Tutorial 1 - Converting a Project from the ADO Data Control to True DataControl
  • Tutorial 2 - Using True DataControl with a Database
  • Tutorial 3 - Using True DataControl with Memory Data
  • Tutorial 4 - Calculated Fields and True DataControl Expressions
  • Tutorial 5 - Implementing Master-Detail Relationships
  • Tutorial 6 - A Common Example of a Master-Detail Relationship
  • Tutorial 7 - Parameters and Dynamic SQL
  • Tutorial 8 - Ad-hoc Queries Using True DataControl Range Conditions
  • Tutorial 9 - Automatic Updating of Control Properties
  • Tutorial 10 - Using Filter Conditions
  • Tutorial 11 - Imposing Constraints and Related Issues
  • Tutorial 12 - One-to-One Links and Linked Fields
  • Tutorial 13 - One-to-One Links and Memory-Based Controls
  • Tutorial 14 - Creating Custom Data Sources in Code
  • Tutorial 15 - Query Mode (part 1)
  • Tutorial 16 - Query Mode (part 2)
• Tutorials - True DataControl Lite
  • Tutorial 1 - Using TDataLite with Bound Controls: ComponentOne TDBGrid and Other Controls
  • Tutorial 2 - Crosstab
  • Tutorial 3 - Using TDataLite with Memory Data
  • Tutorial 4 - Calculated Fields and TDataLite Expressions
  • Tutorial 5 - Automatic Updating of Control Properties by TDataLite
  • Tutorial 6 - Using Filter Conditions and Parameters in TDataLite
  • Tutorial 7 - Imposing Constraints in TDataLite and Related Issues
  • Tutorial 8 - Query Mode in TDataLite (part 1)
  • Tutorial 9 - Query Mode in TDataLite (part 2)
  • Tutorial 10 - OLAP - Decision Support, Pivot Table
• Object Model
  • True DataControl Objects and Collections
    • TData Control
    • TDataLite Control
    • NamedBookmark Object, NamedBookmarks Collection
    • Constraint Object, Constraints Collection
    • Field Object, Fields Collection
    • FilterExpression Object, FilterExpressions Collection
    • Parameter Object, Parameters Collection
    • PropertyExpression Object, PropertyExpressions Collection
    • RangeCondition Object, RangeConditions Collection
    • RowBuffer Object
    • XArrayDB Object
  • Modifying True DataControl Collections from Code
  • Working with Objects and Collections
• Data Access Modes
  • Data Source Mode
    • Defining SourceRecordset at design time
    • Retrieving Fields from the Data Source at Design Time
    • Events in Creating Recordset at Run Time
    • Setting SourceRecordset and DataSource at Run Time
    • Connection Pooling
    • Optimizing Data access Performance
    • Modifying SourceRecordset from Code
    • Using True DataControl with Master-Detail (hierarchical) ADO Recordsets
  • Memory Array Mode
    • Using Memory Array Mode for Binding Controls to Variables
    • Defining Memory Array Fields and Filling Arrays with Data
    • Manipulating Memory Arrays in Code
    • Bookmarks and Row Numbers
  • User Events Mode
    • Defining Fields for User Events Mode
    • Implementing Handlers for User Events Mode
    • Bookmarks in User Events Mode
    • The RowBuffer Object
      • RowCount Property
      • ColumnCount Property
      • ColumnName Property
      • ColumnIndex Property
      • Bookmark Property
      • Value Property
    • True DataControl User Event Mode and True DBGrid Unbound Mode
      • Correspondence between True DataControl and True DBGrid Events
      • Difference in Handling ApproximatePosition
      • Differences in the UserFindData event
• Query Mode
  • Query Mode in True DataControl Lite
  • Using True DataControl to Formulate a Query
  • True DataControl in Query Mode
  • Displaying Query Results
    • Using one TData Control
    • Using Two TData Controls
  • Tuning True DataControl Fields For Query Mode
    • Field Visibility
    • Field Comparison Operation
    • Using Multiple Query Fields for a Single Result Field
• Fields, Parameters and Expressions
  • True DataControl Fields
    • Three Kinds of Fields
    • Accessing Field Values in Code
    • Field Properties
    • Field Range Conditions
    • Field Constraints
  • True DataControl Parameters
    • Parameters in Expressions
    • Parameterized SQL
    • Accessing Parameter Values in Code
  • True DataControl Expressions
    • Specifying Expressions using VBScript
    • Constant and Non-String Expressions
    • Expression Scope Levels
    • Expression Evaluation Modes
    • Expression Evaluation Rules
• Features and Techniques
  • Master-Detail Relationships
  • One-to-One Links
  • Filters
  • Control Property Expressions
  • Modifying Field Values, Retrieving and Saving Them in the Data Source
    • Null Handling
    • Retrieving and Storing Values in the Data Source
    • Modifying Field Value Entered by the User
  • Using TData in Distributed Applications (disconnected recordset support)
  • Field Modification Modes
  • Validation and Constraints
    • Field Validation
    • Standard Error Message in Field Validation
    • Using Error Event in Field Validation
    • Record Validation
    • True DataControl Error Handling and Bound Controls
  • Crosstab (matrix) Data Presentation
  • OLAP: Decision Support, Pivot Table
  • Using True DataControl in Different Containers
    • Cannot Bind Elements of Control Array in Visual Basic
    • Field Modification Modes work only in Visual Basic
    • The NameSubstitute Property Must Be Used in VC++
    • Master Control Cannot Be Chosen From Combo Box in VC++
    • Property Expressions Not Working in VC++
• End-User Interface Features
  • Find Dialog
  • Bookmarks Dialog
    • Handling the GetBookmarkName Event
    • The NamedBookmarks Collection
  • True DataControl Buttons
  • Repeat Feature and Tooltips
  • Button Properties
    • Button Visibility
    • Identifying a Button in Code
    • Button Enabled State
  • Invoking and Substituting Button Functions in Code
  • Customizing User Interface Strings and Images
• Property Pages
  • True DataControl Context Menu
  • Using True DataControl Property Pages
    • Syntax Checking
    • Expression Editing
    • DataSource Page
    • General Page
    • Parameters Page
    • Fields Page
    • Filters Page
    • Property Expressions Page
    • Constraints Page
    • Crosstab Page
• True DataControl 8.0 Reference
  • Constraint Object
    • Constraint Object All Members
    • Constraint Object Properties
      • ConditionExpression Property (Constraint)
      • ConstraintExpression Property (Constraint)
      • MessageExpression Property (Constraint)
  • Constraints Collection
    • Constraints Collection All Members
    • Constraints Collection Properties
      • Count Property (Constraints)
      • Item Property (Constraints)
    • Constraints Collection Methods
      • Add Method (Constraints)
      • Remove Method (Constraints)
  • Field Object
    • Field Object All Members
    • Field Object Properties
      • CalcConditionExpression Property
      • CalculatedExpression Property
      • Constraints Property (Field)
      • DataSourceField Property (Field)
      • DataSourceReadOnly Property
      • DataSourceRequired Property
      • DataSourceType Property
      • DefaultExpression Property
      • DisplayName Property (Field)
      • Exists Property
      • FieldKind Property
      • LinkedControl Property
      • LinkedField Property
      • MaxLength Property
      • ModificationMode Property
      • Name Property
      • QueryMode Property (Field)
      • QueryOperation Property
      • RangeConditions Property
      • ReadOnly Property
      • Required Property
      • Searchable Property
      • Type Property (Field)
      • Value Property (Field)
      • Visible Property (Field)
      • XTabColDef Property
      • XTabColumns Property (Field)
  • Fields Collection
    • Fields Collection All Members
    • Fields Collection Properties
      • Count Property (Fields)
      • Item Property (Fields)
    • Fields Collection Methods
      • Add Method (Fields)
      • Remove Method (Fields)
  • FilterExpression Object
    • FilterExpression Object All Members
    • FilterExpression Object Properties
      • ConditionExpression Property (FilterExpression)
      • FilterExpression Property (FilterExpression)
  • FilterExpressions Collection
    • FilterExpressions Collection All Members
    • FilterExpressions Collection Properties
      • Count Property (FilterExpressions)
      • Item Property (FilterExpressions)
    • FilterExpressions Collection Methods
      • Add Method (FilterExpressions)
      • Remove Method (FilterExpressions)
  • NamedBookmark Object
    • NamedBookmark Object All Members
    • NamedBookmark Object Properties
      • Name Property (NamedBookmark)
      • Value Property (NamedBookmark)
  • NamedBookmarks Collection
    • NamedBookmarks Collection All Members
    • NamedBookmarks Collection Properties
      • Count Property (NamedBookmarks)
      • Item Property (NamedBookmarks)
    • NamedBookmarks Collection Methods
      • Add Method (NamedBookmarks)
      • Remove Method (NamedBookmarks)
  • Parameter Object
    • Parameter Object All Members
    • Parameter Object Properties
      • Name Property (Parameter)
      • SQLParameter Property
      • Type Property (Parameter)
      • Value Property (Parameter)
      • ValueExpression Property (Parameter)
  • Parameters Collection
    • Parameters Collection All Members
    • Parameters Collection Properties
      • Count Property (Parameters)
      • Item Property (Parameters)
    • Parameters Collection Methods
      • Add Method (Parameters)
      • Remove Method (Parameters)
  • PropertyExpression Object
    • PropertyExpression Object All Members
    • PropertyExpression Object Properties
      • ControlName Property
      • PropertyName Property
      • ValueExpression Property (PropertyExpression)
  • PropertyExpressions Collection
    • PropertyExpressions Collection All Members
    • PropertyExpressions Collection Properties
      • Count Property (PropertyExpressions)
      • Item Property (PropertyExpressions)
    • PropertyExpressions Collection Methods
      • Add Method (PropertyExpressions)
      • Remove Method (PropertyExpressions)
  • RangeCondition Object
    • RangeCondition Object All Members
    • RangeCondition Object Properties
      • ComparisonOperation Property
      • ConditionExpression Property (RangeCondition)
      • SkipIfEmpty Property
      • ValueExpression Property (RangeCondition)
  • RangeConditions Collection
    • RangeConditions Collection All Members
    • RangeConditions Collection Properties
      • Count Property (RangeConditions)
      • Item Property (RangeConditions)
    • RangeConditions Collection Methods
      • Add Method (RangeConditions)
      • Remove Method (RangeConditions)
  • RowBuffer Object
    • RowBuffer Object All Members
    • RowBuffer Object Properties
      • Bookmark Property
      • ColumnCount Property
      • ColumnIndex Property
      • ColumnName Property
      • RowCount Property
      • Value Property (RowBuffer)
  • True DataControl Control
    • TData Control All Members
    • TData Control Properties
      • AllowEarlyOpen Property
      • Appearance Property
      • ApproxCount Property
      • Array Property
      • AutoRefresh Property
      • BackColor Property
      • BOFAction Property
      • ButtonAdd Property
      • ButtonBookmark Property
      • ButtonCancel Property
      • ButtonDelete Property
      • ButtonFind Property
      • ButtonFirst Property
      • ButtonNext Property
      • ButtonPage Property
      • ButtonQuery Property
      • ButtonUpdate Property
      • CacheSize Property
      • CallDataRead Property
      • CallDataWrite Property
      • Caption Property
      • ChangeInProgress Property
      • CommandTimeout Property
      • CommandType Property
      • ConfirmCancel Property
      • ConfirmDelete Property
      • ConnectionString Property
      • ConnectionTimeout Property
      • Constraints Property
      • ConvertEmptyToNull Property
      • ConvertNullToEmpty Property
      • CursorLocation Property
      • CursorType Property
      • DataMember Property
      • DataMode Property
      • DataSource Property
      • DesignConnection Property
      • DesignTimeout Property
      • Enabled Property
      • EOFAction Property
      • ErrorMsgCaption Property
      • ErrorMsgRestore Property
      • Fields Property
      • Filtered Property
      • FilterExpressions Property
      • Font Property
      • ForeColor Property
      • LinkType Property
      • LockType Property
      • ManualUpdate Property
      • Master Property
      • MaxRecords Property
      • Mode Property
      • MouseIcon Property
      • MousePointer Property
      • NameSubstitute Property
      • NamedBookmarks Property
      • Orientation Property
      • PageSize Property
      • Parameters Property
      • Password Property
      • PooledConnectionCount Property
      • PooledConnections Property
      • PropertyExpressions Property
      • QueryFilter Property
      • QueryMode Property
      • Recordset Property
      • RecordSource Property
      • RefreshOnSrcChange Property
      • ResyncAfterUpdate Property
      • SafeMode Property
      • SourceConnection Property
      • SourceRecordset Property
      • Tooltips Property
      • UserName Property
    • TData Control Methods
      • ArrayIndexToBookmark Method
      • BookmarkToArrayIndex Method
      • ButtonEnabled Method
      • CancelUpdate Method
      • Drag Method
      • EnableButton Method
      • Move Method
      • PressButton Method
      • Refresh Method
      • RaiseError Method
      • RetrieveFields Method
      • SetButtonPicture Method
      • SetUIString Method
      • ShowWhatsThis Method
      • UpdateFields Method
      • ZOrder Method
    • TData Control Events
      • ButtonPressed Event
      • ButtonStateChanged Event
      • CalcFields Event
      • CalcFieldsComplete Event
      • DataRead Event
      • DataWrite Event
      • Error Event
      • FieldChangeComplete Event
      • Filter Event
      • FilterComplete Event
      • GetBookmarkName Event
      • MoveComplete Event
      • OpenData Event
      • OpenDataComplete Event
      • RecordChangeComplete Event
      • RecordsetChangeComplete Event
      • UserAddData Event
      • UserDeleteRow Event
      • UserFindData Event
      • UserReadData Event
      • UserWriteData Event
      • WillChangeField Event
      • WillChangeRecord Event
      • WillChangeRecordset Event
      • WillMove Event
      • WillOpenData Event
  • True DataControl Lite Control
    • TDataLite Control All Members
    • TDataLite Control Properties
      • Appearance Property (TDataLite)
      • Array Property (TDataLite)
      • BackColor Property (TDataLite)
      • BOFAction Property (TDataLite)
      • ButtonAdd Property (TDataLite)
      • ButtonBookmark Property (TDataLite)
      • ButtonCancel Property (TDataLite)
      • ButtonDelete Property (TDataLite)
      • ButtonFind Property (TDataLite)
      • ButtonFirst Property (TDataLite)
      • ButtonNext Property (TDataLite)
      • ButtonPage Property (TDataLite)
      • ButtonQuery Property (TDataLite)
      • ButtonUpdate Property (TDataLite)
      • CallDataRead Property (TDataLite)
      • CallDataWrite Property (TDataLite)
      • Caption Property (TDataLite)
      • ChangeInProgress Property (TDataLite)
      • ConfirmCancel Property (TDataLite)
      • ConfirmDelete Property (TDataLite)
      • Constraints Property (TDataLite)
      • ConvertEmptyToNull Property (TDataLite)
      • ConvertNullToEmpty Property (TDataLite)
      • DataMember Property (TDataLite)
      • DataMode Property (TDataLite)
      • DataSource Property (TDataLite)
      • Enabled Property (TDataLite)
      • EOFAction Property (TDataLite)
      • ErrorMsgCaption Property (TDataLite)
      • Fields Property (TDataLite)
      • Filtered Property (TDataLite)
      • FilterExpressions Property (TDataLite)
      • Font Property (TDataLite)
      • ForeColor Property (TDataLite)
      • LockType Property (TDataLite)
      • ManualUpdate Property (TDataLite)
      • MouseIcon Property (TDataLite)
      • MousePointer Property (TDataLite)
      • NamedBookmarks Property (TDataLite)
      • PageSize Property (TDataLite)
      • Parameters Property (TDataLite)
      • Pivot Property (TDataLite)
      • PivotColumnDimension Property (TDataLite)
      • PivotConnectionString Property (TDataLite)
      • PivotCubeName Property (TDataLite)
      • PivotFieldsAllLevels Property (TDataLite)
      • PivotMeasure Property (TDataLite)
      • PivotQuery Property (TDataLite)
      • PivotRowDimensions Property (TDataLite)
      • PooledConnectionCount Property (TDataLite)
      • PropertyExpressions Property (TDataLite)
      • QueryFilter Property (TDataLite)
      • QueryMode Property (TDataLite)
      • Recordset Property (TDataLite)
      • RefreshOnSrcChange Property (TDataLite)
      • ResyncAfterUpdate Property (TDataLite)
      • Tooltips Property (TDataLite)
      • XTab Property (TDataLite)
      • XTabColKey Property (TDataLite)
      • XTabCollate Property (TDataLite)
      • XTabRowKey Property (TDataLite)
      • XTabSeparateFields Property (TDataLite)
    • TData Control Methods
      • ArrayIndexToBookmark Method (TDataLite)
      • BookmarkToArrayIndex Method (TDataLite)
      • ButtonEnabled Method (TDataLite)
      • Drag Method (TDataLite)
      • EnableButton Method (TDataLite)
      • Move Method (TDataLite)
      • PivotOpen Method (TDataLite)
      • PressButton Method (TDataLite)
      • Refresh Method (TDataLite)
      • RetrieveFields Method (TDataLite)
      • SetButtonPicture Method (TDataLite)
      • SetUIString Method (TDataLite)
      • ShowWhatsThis Method (TDataLite)
      • ZOrder Method (TDataLite)
    • TData Control Events
      • ButtonPressed Event (TDataLite)
      • ButtonStateChanged Event (TDataLite)
      • CalcFields Event (TDataLite)
      • CalcFieldsComplete Event (TDataLite)
      • DataRead Event (TDataLite)
      • DataWrite Event (TDataLite)
      • Error Event (TDataLite)
      • FieldChangeComplete Event (TDataLite)
      • Filter Event (TDataLite)
      • FilterComplete Event (TDataLite)
      • GetBookmarkName Event (TDataLite)
      • MoveComplete Event (TDataLite)
      • OpenData Event (TDataLite)
      • OpenDataComplete Event (TDataLite)
      • RecordChangeComplete Event (TDataLite)
      • RecordsetChangeComplete Event (TDataLite)
      • WillChangeField Event (TDataLite)
      • WillChangeRecord Event (TDataLite)
      • WillChangeRecordset Event (TDataLite)
      • WillMove Event (TDataLite)
      • WillOpenData Event (TDataLite)
• Constant Reference
  • AutoRefresh Constants
  • BOFAction Constants
  • ComparisonOperation Constants
  • DataMode Constants
  • DataType Constants
  • EOFAction Constants
  • FieldKind Constants
  • LinkType Constants
  • ModificationMode Constants
  • Orientation Constants
  • QueryMode Constants
  • SeekFlag Constants
  • TDButtonEnabledEnum Constants
  • TDButtonEnum Constants
  • TDStringEnum Constants
• VBScript Reference
  • General Category
  • Numeric Category
  • String Category
  • Logical Category
  • Date/Time Category
  • Conversion Category
  • Format Category
    • Field Function
    • IIF Function
    • Format Function
• XArrayDB Reference
  • XArrayDB Members
    • XArrayDB Object Properties
      • Count Property (XArrayDB)
      • DefaultColumnType Property (XArrayDB)
      • LowerBound Property (XArrayDB)
      • Notify Property (XArrayDB)
      • Precision Property (XArrayDB)
      • UpperBound Property (XArrayDB)
      • Value Property (XArrayDB)
    • XArrayDB Object Methods
      • AboutBox Method (XArrayDB)
      • AppendColumns Method (XArrayDB)
      • AppendRows Method (XArrayDB)
      • Clear Method (XArrayDB)
      • Delete Method (XArrayDB)
      • DeleteColumns Method (XArrayDB)
      • DeleteRows Method (XArrayDB)
      • Find Method (XArrayDB)
      • Get Method (XArrayDB)
      • Insert Method (XArrayDB)
      • InsertColumns Method (XArrayDB)
      • InsertRows Method (XArrayDB)
      • LoadRows Method (XArrayDB)
      • QuickSort Method (XArrayDB)
      • ReDim Method (XArrayDB)
      • Set Method (XArrayDB)
  • XArrayDB Object Constants