Goldstar Logo
Your Source for Actian Zen and PSQL Database Products, Services and Training Since 1997 EMail: Sales@goldstarsoftware.com 
Phone: 1-708-647-7665 
Web Site Login 
Free PSQL Support
Quick Links
Database Engines
 Version Quick-Reference Chart
+ Actian Zen v15
+ Actian Zen v14
+ Actian Zen/PSQL v13
+ Actian PSQL v12
+ Actian PSQL v11
+ Pervasive PSQL v10
+ Pervasive PSQL v9
+ Pervasive.SQL V8
+ Pervasive.SQL 2000i
+ Pervasive.SQL 7
+ Btrieve 12
+ Btrieve 6.15
+ Actian Vector

+ Protecting Your Data

+ Goldstar Services

+ Goldstar Tools

+ Developer Resources

+ Other Solutions

Using AMS? Status 7224 Fix My PSQL License Report Engine Crash Repair PSQL Files Get Support Now Join Our Mailing List

Navigation Background

Intermediate Pervasive.SQL 2000 Programming (Btrieve)


Course Developer: Pervasive Software

Level: Intermediate to Advanced

Length: 2 Days

Course Objectives: Intended for programmers with a solid understanding of Pervasive.SQL basics--acquired through experience or by attending our Introduction to Pervasive.SQL 2000 Programming -- this hands-on course thoroughly explores Pervasive.SQL's transactional application programming interface (API), otherwise known as the Btrieve API.

Lectures, demonstrations, and hands-on exercises give attendees all the knowledge and experience they need to successfully create Pervasive.SQL-based applications. In addition to its presentation of intermediate and advanced Btrieve concepts and techniques, the course briefly reviews Internet and intranet development options.

An outline of the course includes:

Section 1 - Review of Architecture and Basics
The MicroKernel Database Engine
Access Modules
Client/Server vs. Workstation Processing
Features of Pervasive.SQL
New Features of Pervasive.SQL
Database File Format
Record Addressing Scheme
Transactions and Shadow Paging
Indexing
International Sorting
Installation Overview
Smart Components


Section 2 - Programming Using the Transactional Interface
The Transactional API
The Transactional Function Call
The Transactional Data Buffer
Byte Alignment
Flow of Control
Compiler Interfaces
Tracing the Transactional API Operations
The Event Log


Section 3 - Basic Btrieve Data Access Techniques
Basic Transactional Operations
Opening and Closing Files
Creating Data Files
Single-Record Positioning and Record Navigation
Single-Record Updating
Other Examples


Section 4 - Direct Addressing and Searching
Direct Addressing
Traversal and Direct Addressing Example
Searching
Other Examples


Section 5 - Additional Tools and Techniques
Continuous Operations Mode
Advanced Indexing
GUI Programming and Btrieve Percentage Operations
Other Examples


Section 6 - Multi-User Programming
Multi-User Programming and Concurrency
Transaction Processing
Other Examples


Section 7 - Advanced Application Techniques
Processing BLOBs (Binary Large Objects) and Chunks
Multiple-Record Processing
Other Examples

Course Prerequisites: Students should be experienced in software development, with Windows development background a plus. Experience in one of three development environments used in the class (Visual BASIC 4/5, Visual C++ or Borland Delphi) is a plus, but not required for advanced individuals.
  Copyright © 1997-2024, Goldstar Software Inc., All rights reserved. PRODUCTS | SERVICES | TRAINING | SUPPORT | DOWNLOADS | ABOUT US  
Goldstar Software Inc. | 1945 Maplewood Ln | Munster IN 46321 Legal Statements | EULAs | Uninstall | Privacy Statements | Contact Us