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