ComponentOne True DBList Pro 8.0
Overview
Product Profile
Installing True DBList Pro 8.0
Set Up Files
Installing Demonstration Versions
Uninstalling True DBList Pro 8.0
Upgrading From Previous Versions
End-User License Agreement
Licensing FAQs
What is Licensing?
How does Licensing Work?
Technical Support
Redistributable Files
Adding the True DBList Components to the Toolbox
Using ComponentOne ActiveX Controls in the .NET Framework
Smart Tags and Tasks Menus
Context Menus
Getting Started
Syntax Changes
Terminology
Using the True DBList and True DBCombo Controls
A Simple Example
Populating the List
Updating Another Data Source
Selecting List Items
Searching the List
Controlling the Display
Differences Between True DBList and True DBCombo
The Basics
Specifying a Data Source
What is Bound Mode?
What is Storage Mode?
What is Application Mode?
What is Unbound Mode?
What is Additem Mode?
Choosing a Column Layout
Automatic Layouts
Customized Layouts
Run-time Layouts
Switching Between Layout Types
Configuring Columns at Design Time
Visual Editing
Specifying database fields
Specifying Other Column Properties
Configuring Columns at Run Time
Adding and Removing Columns
Referencing Column Objects
Adjusting Column Properties in Code
Understanding Bookmarks
True DBList Samples
Tutorials
Tutorial 1 - Binding True DBList to a Data Control
Tutorial 2 - Incremental Search and Auto Completion with True DBCombo
Tutorial 3 - Lookup Combo Update with Two Data Controls
Tutorial 4 - Displaying Master-Detail Relationships
Tutorial 5 - Using True DBList with SQL Query Results
Tutorial 6 - Selecting Multiple Rows Using Bookmarks
Tutorial 7 - Defining Unbound Columns in a Bound List
Tutorial 8 - Displaying Translated Data
Tutorial 9 - Enhancing the User Interface with In-Cell Bitmaps
Tutorial 10 - Using Styles to Highlight Related Data
Tutorial 11 - Displaying Rows in Alternating Colors
Tutorial 12 - Creating a List with Fixed, Nonscrolling Columns
Tutorial 13 - Displaying Array Data in Unbound Mode
Tutorial 14 - Displaying Array Data in Unbound Extended Mode
Tutorial 15 - Displaying Array Data in Unbound Application Mode
Tutorial 16 - Displaying Array Data in Unbound Storage Mode
Tutorial 17 - Sorting and Searching
Tutorial 18 - Displaying Arbitrary Bitmaps
Tutorial 19 - Reusable Layouts
Tutorial 20 - Printing, Print Preview, and Export
Tutorial 21 - Cell Bordering and Scroll Tips/Tracking
Tutorial 22 - Performing a List Search Using the Find Method
Tutorial 23 - Outlook-Style Grouping (OLEDB Only)
Object Model
True DBList Pro Objects and Collections
TDBList and TDBCombo Controls
Column Object, Columns Collection
DataObject Object, DataObjectFiles Collection
GroupColumns Object
Layouts Object
PrintInfo Object, PrintInfos Collection
RowBuffer Object
SelBookmarks Object
Split Object, Splits Collection
Style Object, Styles Collection
ValueItem Object, ValueItems Collection
XArrayDB Object
Working with Objects and Collections
Design Time Interaction
Context Menu
Visual Editing Mode
Sizing columns and rows
Creating and sizing splits
Selecting and highlighting columns
Moving selected columns
Using the visual editing menu
Property Page Overview
Working with property pages
Working with property trees
Changing values in property trees
Boolean properties
String properties
String selection properties
Numeric properties
Enumerated properties
Font properties
Color properties
Picture properties
Style properties
Layout properties
Understanding the object model
Splits in property trees
Columns in property trees
Using the property tree context menu
True DBList Property Pages
General property page (TDBList)
General properties by alphabet
General properties by category
General property page (TDBCombo)
General properties by alphabet (TDBCombo)
General properties by category (TDBCombo)
Columns property page
Column properties by alphabet
Column properties by category
Splits property page
Split properties by alphabet
Split properties by category
Split-specific Column properties by alphabet
Split-specific Column properties by category
Style Factory property page
Using the Style Factory property page
Style properties by alphabet
Style properties by category
Values property page
Using the Values property page
ValueItems properties
ValueItem properties
Print Info property page
Using the Print Info property page
PrintInfo properties
Reusable Layouts
Saving the current layout
Loading a saved layout
Removing a saved layout
Run Time Interaction
Navigation and Scrolling
Mouse navigation
Row tracking (TDBCombo only)
Clicking the rightmost column
IntelliMouse support
Keyboard navigation
Searching and Field Completion
Searching in TDBList
Searching in TDBCombo
Field completion (TDBCombo only)
Search Mismatch (TDBCombo only)
Selection and Movement
Selecting columns
Moving columns
Selecting rows (TDBList only)
Sizing and Splitting
Sizing rows
Sizing columns
Sizing splits
Drag-and-Drop Behavior
Additional User Interaction Features
Bound Mode
Binding True DBList Pro Controls to a Data Source
Binding to an ICursor data source
Binding to an OLE DB data source
Visual Basic Data Control Considerations
How True DBList reacts to Recordset changes
Interactions between True DBList and the Data control
Using True DBList with a Data control on a different form
Using True DBList to display SQL query results
Remote Data Control (RDC) Considerations
Unbound Columns
Creating unbound columns
Implementing unbound columns using Recordset clones
Implementing unbound columns using cell access methods
Implementing multiple unbound columns
Storage Mode
When to Use Storage Mode
Using the XArrayDB Object
Adding XArrayDB to a Visual Basic Project
Creating an XArrayDB Object
Redimensioning an XArrayDB Object
Populating an XArrayDB Object
Attaching an XArrayDB Object to a True DBList Control
Interactions between True DBList and XArrayDB
Updating XArrayDB Elements
Inserting and Removing XArrayDB Rows
Inserting and Removing XArrayDB Columns
Storage Mode Examples
Application Mode
When to Use Application Mode
How Application Mode Works
Application Mode Bookmarks
Bookmarks in True DBList
Bookmarks in Visual Basic
Application Mode Events
Handling the UnboundGetRelativeBookmark event in mode 3
Handling the ClassicRead Event in Mode 3
Application Mode Programming Considerations
Refreshing the Display in Mode 3
Reinitializing the List in Mode 3
Application Mode Example
Unbound Mode
When to Use Unbound Mode
How Unbound Mode Works
Unbound Mode Bookmarks
Using the RowBuffer Object
Unbound Mode Events
Handling the UnboundReadData Event in Mode 1
Handling the UnboundGetRelativeBookmark event in mode 1
Handling the UnboundReadDataEx event in mode 2
UnboundReadDataEx event examples
Unbound Mode Programming Considerations
Refreshing the display in mode 1
Refreshing the display in mode 2
Reinitializing the list in modes 1 and 2
Calibrating the vertical scroll bar in modes 1 and 2
Unbound Mode Examples
AddItem Mode
When to Use AddItem Mode
How AddItem Mode Works
Database Programming Techniques
Changing the Current Record Position
Using the Bookmark property
Accessing Cell Data
Reading cell data within the current record
Reading cell data from non-current records
Retrieving a bookmark relative to the current record
Retrieving a bookmark relative to a displayed row
Selecting and Highlighting Records
Refreshing the Display
Refetching Data from the Data Source
Postponing Illegal Operations in List Events
Searching Bookmarks Using the Find Method
Find Method Simple Code Example:
Customizing the List's Appearance
Captions, Headers, and Footers
Column and list captions
Column footers
Multiple-line headers and footers
Split captions
Three-dimensional versus Flat Display
Borders and Dividing Lines
Modifying the Cell Border Appearance
3D Appearance
Border Thickness
Border Color
Customizing the Scrollbars
Unpopulated Regions
The rightmost column
Unused data rows
Row Height and Multiple-line Displays
Adjusting the height of all list rows
Enabling wordwrap in cells
Displaying a single record on multiple lines
Implications of multiple-line mode
Alternating Row Colors
Horizontal and Vertical Alignment
Window Animation
Data Presentation Techniques
Text Formatting
Using Visual Basic's built-in formatting
Formatting with a custom event handler
Automatic Data Translation with ValueItems
What are ValueItems?
Specifying text-to-text translations
Specifying text-to-picture translations
Displaying both text and pictures in a cell
Displaying Boolean values as check boxes
Displaying allowable values as radio buttons
Context-sensitive Help with CellTips
Scroll Tracking and ScrollTips
Data-sensitive Cell Merging
Outlook-Style Grouping
Owner-drawn Cells
How to Use Splits
Referencing Splits and their Properties
Split properties common to TDBList
Split-only properties not supported by TDBList
Creating and Removing Splits
Working with Columns in Splits
Global properties and methods of Column object
Split-specific properties and methods of Column object
Sizing and Scaling Splits
Creating and Resizing Splits through User Interaction
Vertical Scrolling and Split Groups
Horizontal Scrolling and Fixed Columns
How to Use Styles
Built-in Named Styles
Named style defaults
Named style inheritance
Modifying named styles
Working with Style Properties
Modifying a style property directly
Assigning a value to a style property
Named styles versus anonymous styles
Anonymous style inheritance
Shortcut style properties
Applying Styles to Cells
Specifying cell status values
Applying cell styles by contents
Applying cell styles by custom criteria
Cell style evaluation order
Applying Pictures to List Elements
Displaying background pictures
Displaying foreground pictures
True DBList Reference
All True DBList Members
TDBList Control Properties
TDBList Control Methods
TDBList Control Events
Column Object Properties
Column Object Methods
Columns Properties
Columns Methods
DataObject Object Properties
DataObject Object Methods
GroupColumns Collection Properties
GroupColumns Collection Methods
Layouts Collection Properties
Layouts Collection Methods
PrintInfos Properties
PrintInfos Collection Methods
RowBuffer Object Properties
SelBookmarks Collection Properties
SelBookmarks Collection Methods
Split Object Properties
Split Object Methods
Splits Collection Properties
Splits Collection Methods
Style Object Properties
Style Object Methods
Styles Collection Properties
Styles Collection Methods
ValueItem Object Properties
ValueItems Collection Properties
ValueItems Collection Methods
TDBList Properties
TDBList Methods
TDBList Events
TDBCombo Reference
TDBCombo Members
TDBCombo Control Properties
TDBCombo Methods
AboutBox Method (TDBCombo)
AddItem Method (TDBCombo)
AddRegexCellStyle Method (TDBCombo)
CaptureImage Method (TDBCombo)
CellContaining Method (TDBCombo)
ClearFields Method (TDBCombo)
ClearRegexCellStyle Method (TDBCombo)
ClearSelCols Method (TDBCombo)
CloseCombo Method
GetBookmark Method (TDBCombo)
HoldFields Method (TDBCombo)
LoadLayout Method (TDBCombo)
OLEDrag Method
OpenCombo Method
PointAt Method (TDBCombo)
PostMsg Method (TDBCombo)
ReBind Method (TDBCombo)
Refresh Method (TDBCombo)
RemoveItem Method (TDBCombo)
RowBookmark Method (TDBCombo)
RowContaining Method (TDBCombo)
RowTop Method (TDBCombo)
Scroll Method (TDBCombo)
SplitContaining Method (TDBCombo)
TDBCombo Events
Constant Reference
Alignment Constants
AnimateWindow Constants
AnimateWindowClose Constants
AnimateWindowDirection Constants
Appearance Constants
BackgroundPictureDrawMode Constants
BorderAppearance Constants
BorderStyle Constants
BorderType Constants
CellStyle Constants
CellTip Constants
CellTipPresentation Constants
ComboStyle Constants
DataMode Constants
DataView Constants
DividerStyle Constants
DropdownPosition Constants
Error Constants
ExposeCellMode Constants
ForegroundPicturePosition Constants
MatchCol Constants
MatchCompare Constants
MatchEntry Constants
MatchEntry Constants
Menu Constants
MousePointer Constants
MultipleLines Constants
MultiSelect Constants
OLEDragMode Constants
OLEDropMode Constants
PointAt Constants
Presentation Constants
RowSelector Constants
ScrollBars Constants
SplitSizeMode Constants
UnboundFind Constants
VerticalAlignment Constants
PrintInfo Reference
PrintInfo Object Members
PrintInfo Object Properties
PrintInfo Object Methods
GetMenuText Method
GetSubstituteFont Method
PageSetup Method
PrintData Method
PrintPreview Method
SetMenuText Method
SubstituteFont Method
XArrayDB Reference
XArrayDB Object 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
XCOMP
XORDER
XTYPE