arev:arev_2.1

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
arev:arev_2.1 [2023/11/29 19:12] – bshumskyarev:arev_2.1 [Unknown date] (current) – external edit (Unknown date) 127.0.0.1
Line 1: Line 1:
 +====== Table of Contents ======
  
 +===== Volume I =====
 +
 +==== Section A — Introduction ====
 +
 +[[arev:Chapter A 1|Introduction to Advanced Revelation]]
 +
 +About Advanced Revelation
 +
 +About the Documentation
 +
 +Conventions Used in this Book
 +
 +==== Section B — Installation ====
 +
 +[[arev:Chapter B 1|Installing Advanced Revelation]]
 +
 +Preparing Your System for the Installation
 +
 +Installing Advanced Revelation
 +
 +[[arev:Chapter B 2|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
 +
 +[[arev:Chapter B 3|Removing Optional Modules]]
 +
 +Removing Optional Modules
 +
 +[[arev:Chapter B 4|Logging On to Advanced Revelation]]
 +
 +Logging On to Advanced Revelation
 +
 +[[arev:Chapter B 5|Using Expanded Memory Support]]
 +
 +Introduction
 +
 +System Requirements
 +
 +Using Expanded Memory Logon Options
 +
 +Managing Expanded Memory
 +
 +Displaying the Status of Expanded Memory
 +
 +System Configuration
 +
 +==== Section C — Tutorial ====
 +
 +[[arev:Chapter C 1|Introduction to the Online Tutorial]]
 +
 +Introduction to the Online Tutorial
 +
 +Accessing the Tutorial
 +
 +Running a Tutorial Lesson
 +
 +[[arev:Chapter C 2|Introduction to the Sample Application]]
 +
 +Introduction to the Sample Application
 +
 +Accessing the Sample Application
 +
 +Maintaining the Sample Application
 +
 +==== Section D — Getting Started ====
 +
 +[[arev:Chapter D 1|Getting Started]]
 +
 +Starting, Moving Around, and Leaving
 +
 +Getting Online Help
 +
 +Other Important Keys
 +
 +[[arev:Chapter D 2|Using System Features]]
 +
 +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
 +
 +[[arev:Chapter D 3|Entering and Editing Data in Windows]]
 +
 +Moving the Cursor
 +
 +Entering and Editing Data in Windows
 +
 +[[arev:Chapter D 4|Using the Full-Screen Editor]]
 +
 +Introduction to the Full-Screen Editor
 +
 +Using Defined Blocks of Text
 +
 +Searching and Replacing
 +
 +Using Value Windows
 +
 +Using Softkeys in the Full-Screen Editor
 +
 +[[arev:Chapter D 5|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 ====
 +
 +[[arev:Chapter E 1|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
 +
 +[[arev:Chapter E 2|Managing Files and Records]]
 +
 +Defining Files and Fields
 +
 +Defining a File Using the Definefile Window
 +
 +Creating File Synonyms
 +
 +Transaction Processing
 +
 +[[arev:Chapter E 3|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
 +
 +[[arev:Chapter E 4|Advanced Revelation Volumes]]
 +
 +About Volumes
 +
 +Attaching Files in a Volume
 +
 +Creating a Volume
 +
 +Additional Volume Functions 
 +
 +[[arev:Chapter E 5|The Linear Hash Filing System]]
 +
 +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 ====
 +
 +[[arev:Chapter F 1|Building Applications with Advanced Revelation]]
 +
 +Introducing the Application Development Process
 +
 +[[arev:Chapter F 2|Planning an Application]]
 +
 +Planning Checklist 
 +
 +Establishing Application Requirements 
 +
 +Developing an Application Design 
 +
 +Designing the Advanced Revelation Structure 
 +
 +An Application Planning Worksheet 
 +
 +[[arev:Chapter F 3|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 
 +
 +[[arev:Chapter F 4|Creating Windows with Paint]]
 +
 +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 
 +
 +[[arev:Chapter F 5|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 
 +
 +[[arev:Chapter F 6|Building Menus and Popups]]
 +
 +Designing and Building Menus 
 +
 +Displaying a Main Menu in an Application 
 +
 +Designing and Building Popups 
 +
 +Displaying Popups With Codes and Commands
 +
 +[[arev:Chapter F 7|Creating and Maintaining Indexes]]
 +
 +Introduction 
 +
 +Creating Indexes
 +
 +Using Quickdex 2
 +
 +Indexing System Maintenance 
 +
 +Reviewing Index Specifications 
 +
 +Updating and Rebuilding Indexes
 +
 +Developer Notes for Indexing 
 +
 +[[arev:Chapter F 8|Building Formulas]]
 +
 +What is an R/BASIC Formula?
 +
 +Accessing the Formula Window 
 +
 +Glossary of R/BASIC Formula Trigger Words 
 +
 +[[arev:Chapter F 9|Using Codes and Commands]]
 +
 +Where to Use Codes and Commands
 +
 +The Codes and Commands
 +
 +The Code and Command Options 
 +
 +[[arev:Chapter F 10|Using the Batch Update Process]]
 +
 +About Batch Updating 
 +
 +Creating a Batch Update Process 
 +
 +[[arev:Chapter F 11|Writing Macros and Capturing Keystrokes]]
 +
 +Defining and Using Macro Sets 
 +
 +Capturing Keystrokes 
 +
 +[[arev:Chapter F 12|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 ====
 +
 +[[arev:Chapter G 1|Selecting and Browsing Through Data]]
 +
 +Using Record Keys
 +
 +Defining Selection Criteria for Record Key Lists 
 +
 +Using Browse Lists in Application Windows 
 +
 +[[arev:Chapter G 2|Using the Filter Key]]
 +
 +Using the Filter Key 
 +
 +[[arev:Chapter G 3|Using Indexes]]
 +
 +Introducing Advanced Revelation’s Indexing System
 +
 +Index Search Options in Application Windows 
 +
 +[[arev:Chapter G 4|Using Window Query]]
 +
 +Using Window Query in Application Windows 
 +
 +Using Window Query from TCL 
 +
 +Modifying the Environment for Window Query 
 +
 +[[arev:Chapter G 5|Using Query-By-Example]]
 +
 +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 ====
 +
 +[[arev:Chapter H 1|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 
 +
 +[[arev:Chapter H 2|Creating Forms]]
 +
 +Creating Forms 
 +
 +Specifying Form Characteristics 
 +
 +Testing a Form
 +
 +Printing Forms 
 +
 +[[arev:Chapter H 3|Creating Labels]]
 +
 +Creating Labels 
 +
 +Testing a Label Definition 
 +
 +Printing Labels 2
 +
 +[[arev:Chapter H 4|Creating R/LIST Reports]]
 +
 +Creating R/LIST Reports 
 +
 +Using the Make an RList Window 
 +
 +[[arev:Chapter H 5|Writing Reports with EasyWriter]]
 +
 +Introducing EasyWriter 
 +
 +Components of EasyWriter 
 +
 +Developer Notes for EasyWriter 
 +
 +[[arev:Chapter H 6|Creating Merge Reports]]
 +
 +Introducing Advanced Revelation’s Merge Processor 
 +
 +Creating a Merge Template 
 +
 +Entering Scripts 
 +
 +Executing a Merge
 +
 +Special Features of the Merge Processor 
 +
 +==== Section I — TCL ====
 +
 +[[arev:Chapter I 1|Introduction to 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
 +
 +[[arev:Chapter I 2|Features of TCL]]
 +
 +Features of TCL
 +
 +[[arev:Chapter I 3|TCL Command Reference]]
 +
 +TCL Command Reference
 +
 +==== Section J — R/LIST ====
 +
 +[[arev:Chapter J 1|Introduction to R/LIST]]
 +
 +Introduction to R/LIST
 +
 +Using Filters 
 +
 +Query Optimization
 +
 +Sorting in LIST
 +
 +Comparisons in R/LIST
 +
 +[[arev:Chapter J 2|R/LIST Keyword Reference]]
 +
 +R/LIST Command Format
 +
 +R/LIST Format Modifier Keywords 
 +
 +R/LIST Format Override Keywords 
 +
 +R/LIST Throwaway Words 
 +
 +R/LIST Keywords 
 +
 +==== Section K — SQL ====
 +
 +[[arev:Chapter K 1|The SQL Option]]
 +
 +Advanced Revelation SQL
 +
 +Getting to SQL
 +
 +[[arev:Chapter K 2|An Introduction to SQL]]
 +
 +Introduction
 +
 +The Database According to SQL
 +
 +SQL and Advanced Revelation 
 +
 +[[arev:Chapter K 3|Building a Database]]
 +
 +Creating Tables
 +
 +Viewing Information
 +
 +[[arev:Chapter K 4|Querying the Database]]
 +
 +A Query Language 
 +
 +Forming Queries 
 +
 +[[arev:Chapter K 5|Modifying the Database]]
 +
 +Inserting Rows
 +
 +Updating Rows
 +
 +Deleting Rows 
 +
 +Deleting Tables and Views 
 +
 +[[arev:Chapter K 6|Managing the System]]
 +
 +The SQL Environment 
 +
 +Accessing the Dictionary 
 +
 +[[arev:Chapter K 7|Programming with SQL]]
 +
 +Introduction 
 +
 +The SQL Module Language 
 +
 +Embedded SQL 
 +
 +[[arev:Chapter K 8|SQL Reference]]
 +
 +Extensions to SQL
 +
 +Reserved Words
 +
 +Advanced Revelation SQL Data Types
 +
 +SQL Operators and Notation 
 +
 +SQL Keywords 
 +
 +SQL Statements
 +
 +==== Section L — Networks ====
 +
 +[[arev:Chapter L 1|Introduction to Networks]]
 +
 +Introduction 
 +
 +[[arev:Chapter L 2|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 
 +
 +[[arev:Chapter L 3|Locking]]
 +
 +Introduction to Locking 
 +
 +Types of Locking
 +
 +Establishing Locking 
 +
 +Setting Locking Options 
 +
 +Implicit Locking 
 +
 +Additional Lock Issues 
 +
 +===== Volume III =====
 +
 +==== Section M — Environmental Bonding ====
 +
 +[[arev:Chapter M 1|Introduction to Environmental Bonding]]
 +
 +Environmental Bonding 
 +
 +Tenets of Environmental Bonding 
 +
 +Using an Environmental Bond 
 +
 +Characteristics of Environmental Bonding 
 +
 +[[arev:Chapter M 2|The ASCH Environmental Bond]]
 +
 +Description of the ASCII bond 
 +
 +Using the ASCII Bond 
 +
 +[[arev:Chapier M 3|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 ====
 +
 +[[arev:Chapter N 1|Introduction to R/BASIC]]
 +
 +R/BASIC Overview
 +
 +[[arev:Chapter N 2|Features of R/BASIC]]
 +
 +Features of R/BASIC
 +
 +[[arev:Chapter N 3|Programming with R/BASIC]]
 +
 +Programming with R/BASIC 
 +
 +[[arev:Chapter N 4|R/BASIC Command Reference]]
 +
 +R/BASIC Command Reference 
 +
 +[[arev:Chapter N 5|R/BASIC System Subroutines]]
 +
 +R/BASIC System Subroutines