Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== 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 arev/arev_2.1.txt Last modified: 2023/11/29 12:22(external edit)