About This Manual
About This Manual
What You Need To Know
Manual Organization
Notation
Typographic Conventions
Naming Conventions
Related Documentation and Bibliography
Rogue Wave Views Manuals
C++ Programming Language Publications
Database Publications
Rogue Wave Views Data Access Common Framework
Introducing Data Access
What is Data Access?
Libraries
Editors
Supported Databases
Distribution Structure
Data Access Basics
Overview
Rogue Wave Views Interface
IlvDisplay
IlvApplication
Containers
Gadgets
Callbacks
Data Access Concepts
Values
Database Connection
Tables
Data Sources
Data-Source-Aware Gadgets
Formats
Masks
Integrating with Rogue Wave Views Advanced Graphics
Tables
Introduction to Tables
One-Tier and Two-Tier Tables
The Role of a Table Object
Schemas
Schema Properties
Defining the Schema of a Table Object
Managing Rows in a Table
Basic Techniques
Techniques for Two-Tier Tables
Error Catching
Changing Error Messages
Table Hook
Copying and Serializing Table Objects
Specialized Table Subclasses
IliSQLTable
IliMemoryTable
IliStringsTable
IliMapTable
Subclassing IliTable
Guidelines
Subclassing Example
Directory Class Example
Persistence
Table Properties
Scoped Properties
Property-Aware Gadgets
Data Sources and Gadgets
Data Sources
Creating a Data Source Gadget
Connecting Data-Source-Aware Gadgets
The Scope of a Data Source
Managing Rows in a Data Source
Customizing a Data Source
Error Handling
The Repository
Data-Source-Aware Gadgets
Interface to Data-Source-Aware Gadgets
IliTableGadget
IliDbField
IliEntryField
IliTableComboBox
IliDbText
IliDbToggle
IliToggleSelector
IliDbNavigator
IliDbTimer
IliHTMLReporter
IliXML
IliDbPicture
IliDbOptionMenu
IliDbStringList
IliDbTreeGadget
IliChartGraphic
IliDbGrapher
IliDbGantt
Global Callbacks
Handling Values in Data Access
The IliValue Class
Constructing a Value Object
Null Value
Data Types
Checking the Data Type of an Object
Converting a Data Access Data Type to a C++ Type
Formatting an IliValue Object
Structured Types
Hints and Tips for Using Data Access
Working with DbFields in Data Access
The Style of a DbField
Creating a Form Using the Forms Assistant
Foreign Tables
Specifying a Foreign Table in Rogue Wave Views Studio
Using a Foreign Table to Convert Values
Using a Foreign Table to Constrain Values
Using the Forms Assistant with Foreign Tables
Setting the Table Look
Column Geometry
Read-Only Settings
Fixed Columns
Troubleshooting
Avoiding Common Names in Foreign Tables
Matching Types with a Foreign Table
Data Access and SQL
SQL Tables
Introduction
Structural Definition
Creating the Definition Using Rogue Wave Views Studio
Creating the Definition in C++
A Shortcut C++ Definition
The SQL Session of an SQL Table
Run-Time Options
Concurrency Control
Auto-Commit Mode
Fetch Policy
Auto-Refresh Mode
Inserting-Nulls Mode
Dynamic-SQL Mode
Bound Variables Mode
Cursor Buffering
Auto-Row Locking Mode
Parameters
Transaction Manager
Structured Types
Asynchronous Mode
SQL Data Sources
Query Mode
Parameters
Defining a Parameter
Defining a Parameter That Accepts User Input
Working with an SQL Data Source
Defining Columns
Forcing the Name of a Column
The Table Primary Key
Connecting to a Database
SQL Sessions and Cursor Objects
Creating a Session
Connecting to a Database System
Cursors
Database Drivers
The Connect Dialog Box
Registered Sessions
Rogue Wave Views Data Access Gadgets
Rogue Wave Views Studio Data Access Gadgets
The Palettes Panel
Data Access and SQL Gadgets
Charts, Grapher and Gantt Chart Gadgets
SQL Tables
Notebook Pages Common to Data Access Gadgets Inspectors
General Notebook Page
Callbacks Notebook Page
Dialog Boxes Common to Data Access Gadgets Inspectors
Font Chooser Dialog Box
Color Chooser Dialog Box
File Chooser Dialog Box
Data Source Gadgets Reference
IliSQLDataSource
IliSQLDataSource Inspector Panel
IliSQLDataSource Menus
General Elements
SELECT Section Notebook Pages
Dialog Boxes
IliMemoryDataSource
IliMemoryDataSource Inspector Panel
Display Gadgets Reference
IliTableGadget
Table Gadget Inspector Panel
IliDbField
DbField Inspector Panel
IliEntryField
Entry Field Inspector Panel
IliTableComboBox
Table Combo Box Inspector Panel
IliDbText
DbText Inspector Panel
IliDbToggle
DbToggle Inspector Panel
IliToggleSelector
ToggleSelector Inspector Panel
IliDbNavigator
DbNavigator Inspector Panel
IliDbTimer
DbTimer Inspector Panel
IliHTMLReporter
HTMLReporter Inspector Panel
IliXML
XML Inspector Panel
IliDbPicture
DbPicture Inspector Panel
IliDbOptionMenu
DbOptionMenu Inspector Panel
IliDbStringList
DbStringList Inspector Panel
IliDbTreeGadget
DbTreeGadget Inspector Panel
IliChartGraphic
ChartGraphic Inspector Panel
IliDbGrapher
DbGrapher Inspector Panel
IliDbGantt
DbGantt Inspector Panel
Utility Classes
The IliString Class
The IliDecimal Class
The IliDate Class
The IliFormat Class
The IliInputMask Class
Format Syntax
String Formats
Number Formats
Date Formats
Literal Characters
Mask Syntax
Placeholders
Predefined Masks
Error Messages
About This Manual
Error Messages