Table of Contents
Volume I
Section A — Introduction
Introduction to Advanced Revelation
About Advanced Revelation
About the Documentation
Conventions Used in this Book
Section B — Installation
Installing Advanced Revelation
Preparing Your System for the Installation
Installing Advanced Revelation
Updating and Enhancing Your Advanced Revelation System
Installing Optional Modules
Installing a Maintenance Update or Product Upgrade
Upgrading User Accounts
Note to the System Administrator
Removing Optional Modules
Logging On to Advanced Revelation
Logging On to Advanced Revelation
Introduction
System Requirements
Using Expanded Memory Logon Options
Managing Expanded Memory
Displaying the Status of Expanded Memory
System Configuration
Section C — Tutorial
Introduction to the Online Tutorial
Introduction to the Online Tutorial
Accessing the Tutorial
Running a Tutorial Lesson
Introduction to the Sample Application
Introduction to the Sample Application
Accessing the Sample Application
Maintaining the Sample Application
Section D — Getting Started
Starting, Moving Around, and Leaving
Getting Online Help
Other Important Keys
The Advanced Revelation Environment
Managing the Advanced Revelation Environment
The Online Help System
What the Status Line Tells You
Using Menus
Using Windows
Using Popups
Entering and Editing Data in Windows
Moving the Cursor
Entering and Editing Data in Windows
Introduction to the Full-Screen Editor
Using Defined Blocks of Text
Searching and Replacing
Using Value Windows
Using Softkeys in the Full-Screen Editor
Configuring for the Workstation: Mouse, Display, and Printers
Using High-Density Screens
Using a Mouse with Advanced Revelation
Using Printers with Advanced Revelation
Printing and Displaying R/BASIC Reports
Section E — Filing Systems
Advanced Revelation Files and Records
About Files & Records
Terminology: Files, Records, and Fields
Characteristics of Advanced Revelation Files
Characteristics of Advanced Revelation Records
Characteristics of Advanced Revelation Fields
Defining Files and Fields
Defining a File Using the Definefile Window
Creating File Synonyms
Transaction Processing
Advanced Revelation Dictionaries
About Advanced Revelation’s Dictionaries
Creating a Data Dictionary
Dictionary Record Types
Creating Temporary Fields for Reports
Paint Autobinding
Available Dictionary Reports
Dictionary Characteristics and Record Format
About Volumes
Attaching Files in a Volume
Creating a Volume
Additional Volume Functions
The Linear Hash Filing System
How Linear Hash Files Work
Testing Linear Hash Files
Redefining Linear Hash Files
Group Format Errors(GFEs)
Fixing GFEs Using DUMP
LH_VERIFY Output File Layouts
Testing Files from within R/BASIC Programs
LH_VERIFY Error Codes
Section F — Developing an Application
Building Applications with Advanced Revelation
Introducing the Application Development Process
Planning Checklist
Establishing Application Requirements
Developing an Application Design
Designing the Advanced Revelation Structure
An Application Planning Worksheet
Users & Accounts: Planning Access and Security
Introducing Users and Accounts
Planning for Security
Setting Up Accounts
Setting Up Users
Setting Up Environments
Setting Video Attributes
Assigning Environment and Video Characteristics
Overview of the Painting Process
Getting Started
Adding, Changing, and Removing Prompts and Entry Lines
Adding, Changing, and Removing Labels
Using Paint Options
Resizing and Moving Your Window
Testing Your Window with Test Run
Adding Advanced Features to Windows with Paint
The Advanced Paint Options
Grouping and Reordering Prompts
Using Default and Duplicate Prompts
Defining Advanced Prompt Characteristics
Defining Smart Labels
Using Prompt Formulas
Displaying, Editing, and Updating Dictionaries
Data Validation
Data Formatting
Quick Painting Windows
Using the Paint Indexing Menu
Customizing Windows
Creating Custom Softkeys
Relating Windows
Setting Window Video Attributes
Establishing Window Security
Disabling Window Keys
Defining Collector Windows
Adding Window Processing
Developer Notes for Paint
Designing and Building Menus
Displaying a Main Menu in an Application
Designing and Building Popups
Displaying Popups With Codes and Commands
Creating and Maintaining Indexes
Introduction
Creating Indexes
Using Quickdex 2
Indexing System Maintenance
Reviewing Index Specifications
Updating and Rebuilding Indexes
Developer Notes for Indexing
What is an R/BASIC Formula?
Accessing the Formula Window
Glossary of R/BASIC Formula Trigger Words
Where to Use Codes and Commands
The Codes and Commands
The Code and Command Options
Using the Batch Update Process
About Batch Updating
Creating a Batch Update Process
Writing Macros and Capturing Keystrokes
Defining and Using Macro Sets
Capturing Keystrokes
International Applications Support
Introduction to International Support
Understanding Language Sets
Understanding Character Sort Order
Developing Applications for International Use
Creating Applications
Volume II
Section G — Accessing Data
Selecting and Browsing Through Data
Using Record Keys
Defining Selection Criteria for Record Key Lists
Using Browse Lists in Application Windows
Using the Filter Key
Introducing Advanced Revelation’s Indexing System
Index Search Options in Application Windows
Using Window Query in Application Windows
Using Window Query from TCL
Modifying the Environment for Window Query
Introducing Query-By-Example
Query-By-Example Basics
Creating Query-By-Example Queries
Working with the Result Display
Including Calculated Columns in the Results
Section H — Creating Reports
Creating Reports with Advanced Revelation
Overview of Advanced Revelation Reports
Overview of Advanced Revelation Report Tools
Customizing the Data Dictionary for Reports
Using View for R/LIST Reports
Developer Notes for View
Creating Forms
Specifying Form Characteristics
Testing a Form
Printing Forms
Creating Labels
Testing a Label Definition
Printing Labels 2
Creating R/LIST Reports
Using the Make an RList Window
Writing Reports with EasyWriter
Introducing EasyWriter
Components of EasyWriter
Developer Notes for EasyWriter
Introducing Advanced Revelation’s Merge Processor
Creating a Merge Template
Entering Scripts
Executing a Merge
Special Features of the Merge Processor
Section I — TCL
Introducing TCL
What is the VOC File?
Adding, Deleting, and Renaming TCL Commands
Displaying TCL Command Windows
Executing TCL Commands from R/BASIC Programs
Features of TCL
TCL Command Reference
Section J — R/LIST
Introduction to R/LIST
Using Filters
Query Optimization
Sorting in LIST
Comparisons in R/LIST
R/LIST Command Format
R/LIST Format Modifier Keywords
R/LIST Format Override Keywords
R/LIST Throwaway Words
R/LIST Keywords
Section K — SQL
Advanced Revelation SQL
Getting to SQL
Introduction
The Database According to SQL
SQL and Advanced Revelation
Creating Tables
Viewing Information
A Query Language
Forming Queries
Inserting Rows
Updating Rows
Deleting Rows
Deleting Tables and Views
The SQL Environment
Accessing the Dictionary
Introduction
The SQL Module Language
Embedded SQL
Extensions to SQL
Reserved Words
Advanced Revelation SQL Data Types
SQL Operators and Notation
SQL Keywords
SQL Statements
Section L — Networks
Introduction
Managing Advanced Revelation on a Network
Managing Files on a Network
The Advanced Revelation Environment
Executing Network Commands
Managing Indexing on a Network
Other Network Management Issues
Introduction to Locking
Types of Locking
Establishing Locking
Setting Locking Options
Implicit Locking
Additional Lock Issues
Volume III
Section M — Environmental Bonding
Introduction to Environmental Bonding
Environmental Bonding
Tenets of Environmental Bonding
Using an Environmental Bond
Characteristics of Environmental Bonding
Description of the ASCII bond
Using the ASCII Bond
The dBASE II Environmental Bond
Description of the dBASE III Bond
Using the dBASE III Bond
The dBASE ITI Bond Reference
Section N — R/BASIC
R/BASIC Overview
Features of R/BASIC
Programming with R/BASIC
R/BASIC Command Reference
R/BASIC System Subroutines