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 - 2023 ComponentAce  | .net zip component | barcode for .net | delphi zip component | delphi database Jan 31, 2023