Chapter 1: Introduction to ADO
ADO Support in Delphi
Books and Information Sources
Third Party ADO DataSets
ADO Versions
DBGO
Getting Started
OLE DB Providers
Third Party OLE DB Providers
Connection String Arguments
TADOConnection
Data Link Files
Getting the ADO Version Number
Dynamic Properties
Schema Information
BDE Tools and TheirADO Equivalents
Converting BDE Applications to ADO
Undocumented Functions
Data Shaping
Updating JOINs
Redistributing MDAC
Programmatically Creating ODBC Data Sources
Component Checker
Getting the ADO Version Number Without Using a Connection
Summary
Chapter 2: ADO JET OLE DB Provider (JOLT)
History
Getting the JET Engine
Using Paradox
Accessing Excel Spreadsheets
JET OLE DB Provider Extended Properties
Using text
Exporting Data to Excel
Exporting Data to Paradox and HTML
Opening an HTML File as a Table
Chapter 3: ADO Cursor Types
Client Side Cursors vs. Server Side Cursors
Cursor Types
Forwards Only Cursors
Static Cursors
Keyset Cursors
Dynamic Cursors
Cursor Update Visibility
Cursor Locations and Cursor Types
Client Side Cursors and Client Databases
|
Chapter 4: ADO Transaction
Processing
Building a Test Application
Determining TP Support
Paradox Transaction Processing Revisited
Access Transaction Processing
Nested Transactions
Lock Types
Page Locking and Row Locking-in Access
Controlling Locking-in Access
Pessimistic Locking Using Access
Transaction Isolation Levels
Summary
Chapter 5: ADO Batch Updates
Checking Pending Updates
Update Conflicts
Resolving Conflicts
Master/Detail Relationships
Disconnected Recordsets
Persisting Data Locally
Briefcase Applications
Summary
Chapter 6: ADO Persistent Recordsets
Single Tier Applications
TADODdataset Local Indexes
Indexing in a DBGrid
Custom (fabricated) Datasets
XML Support
In Memory Tables
Summary
Chapter 7: ADOX Extensions for DDL and Security
Importing the ADOX Type Library
ADOX Object Model
Catalogs
Collections
Tables
Columns
Creating a Table
Adding an AutoIncrement Column
Altering a Column
Indexes
Keys
Procedures
Unsupported Features
Security
Summary
|
