Delphi Database, Delphi Components from ComponentAce
Products Download Order Contact us
Absolute Database Manual

Absolute Database Manual
Getting Started
Overview
Getting Help
Creating and Deleting Databases
Creating and Deleting Tables
Connecting to Databases
Opening and Closing Tables
Executing Queries
Using Parameters in Queries
Navigating Tables and Queries
Using Data Controls
Accessing Table and Query Fields
Searching Records
Creating Filters
Adding New Records
Editing Records
Deleting Records
Sorting Records with Indexes
Advanced Topics
Locking and Multi-User Access
Transactions
Restructuring Tables
Emptying Tables
Copying Tables
Accessing BLOB Fields
Compressing BLOB Fields
Importing and Exporting Records
In-Memory Tables
Encrypting Databases
Compacting Databases
Repairing Databases
Optimizations
Overview
Making the Database File Smaller
Improving Overall Performance
Speeding up Searches and Filters
Improving SQL Performance
Increasing Inserts and Updates Speed
Internationalization
Overview
Formats
Sort Order
Unicode
Migration from the BDE
Why Not Use the BDE
Why Migrate to the Absolute Database
How to Migrate from the BDE
Differences from the BDE
SQL Reference
Overview
Naming Conventions
Functions and Operators
Comparison Operators
Logical Operators
Arithmetic Operators
String Concatenation Operator
String Functions
Mathematical Functions
Date Functions
Aggregate Functions
Data Conversion Functions
System Functions
Conditional Expressions
SQL Commands
SELECT Command
Subqueries
INSERT Command
UPDATE Command
DELETE Command
CREATE TABLE Command
ALTER TABLE Command
DROP TABLE Command
TRUNCATE TABLE Command
CREATE INDEX Command
DROP INDEX Command
START TRANSACTION Command
COMMIT Command
ROLLBACK Command
Components Reference
TABSDatabase
TABSTable
TABSQuery
TABSSession
TABSBlobStream
TABSDataSet
FAQ
Absolute DB FAQ
Appendix
Maximum Capacity Specifications
Field Data Types
Error Codes
Reserved Words


        © 2003 - 2024 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Mar 29, 2024