Web Search

Overview of PSQL Access Methods
Overview of PSQL Access Methods
SQL Access in PSQL
Developer Quick Start
Choosing An Access Method
Database Connection Quick Reference
ODBC Information
Additional Resources for Application Developers
Developing Applications for the MicroKernel Engine
MicroKernel Engine Environment
Configuration Issues for MicroKernel Engine
MicroKernel Engine Fundamentals
Overview of the MicroKernel Engine
Pages
File Types
Data Types
Key Attributes
Database URIs
Double-Byte Character Support
Record Length
Data Integrity
Event Logging
Performance Enhancement
Disk Usage
Designing a Database
Understanding Data Files
Creating a Data File
Calculating the Logical Record Length
Choosing a Page Size
Estimating File Size
Optimizing Your Database
Setting Up Security
Language Interfaces Modules
Interface Modules Overview
C/C++
Delphi
DOS (Btrieve)
Pascal
Visual Basic
Interface Libraries
Overview of Interface Libraries
Distributing PSQL Applications
Working with Records
Sequence of Operations
Accessing Records
Inserting and Updating Records
Multi-Record Operations
Adding and Dropping Keys
Supporting Multiple Clients
Btrieve Clients
Passive Concurrency
Record Locking
User Transactions
Examples of Multiple Concurrency Control
Concurrency Control for Multiple Position Blocks
Multiple Position Blocks
ClientID Parameter
Debugging Your Btrieve Application
Trace Files
Indirect Chunk Operations in Client/Server Environments
Engine Shutdowns and Connection Resets
Reducing Wasted Space in Files
Btrieve API Programming
Fundamentals of Btrieve API Programming
Visual Basic Notes
Delphi Notes
Starting a PSQL Application
Btrieve API Code Samples
Declarations of Btrieve API Functions for Visual Basic
Creating a Database
Named Databases
Bound Databases
Creating Database Components
Naming Conventions
Creating a Data Dictionary
Creating Tables
Creating Columns
Creating Indexes
Relational Database Design
Overview of Database Design
Stages of Design
Inserting and Deleting Data
Overview of Inserting and Deleting Data
Inserting Values
Transaction Processing
Deleting Data
Dropping Indexes
Dropping Columns
Dropping Tables
Dropping an Entire Database
Modifying Data
Overview of Modifying Data
Modifying Tables
Setting Default Values
Using UPDATE
Retrieving Data
Overview of Retrieving Data
Views
Selection Lists
Sorted and Grouped Rows
Joins
Subqueries
Restriction Clauses
Functions
Storing Logic
Stored Procedures
SQL Variable Statements
SQL Control Statements
SQL Triggers
Managing Data
Overview of Managing Data
Defining Relationships Among Tables
Keys
Referential Constraints
Referential Integrity in the Sample Database
Administering Database Security
Concurrency Controls
Atomicity in PSQL Databases
Sample Collations Using International Sorting Rules
German Sample Collations
Spanish Sample Collations
French Sample Collations
Sample Database Tables and Referential Integrity
Overview of the Demodata Sample Database
Structure of the Demodata Sample Database
Referential Integrity in the Demodata Sample Database
Table Design of the Demodata Sample Database