CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Rules and Hints for Using ADE

  1.1     Naming Conventions

  1.2     Abbreviations

  1.3     Column Types
    1.3.1      CHARACTER Columns
    1.3.2      NUMERIC Columns
    1.3.3      DATE Columns
    1.3.4      KEY Columns

  1.4     Defining Column Types

  1.5     Specifying Worksheet Columns in Commands

  1.6     Specifying Worksheet Lines in Commands

  1.7     ADE Size Limits
    1.7.1      Column and Line Size
    1.7.2      Table Size

  2      OPTIONAL PHRASES

  2.1     The WHERE and EXCEPT Phrases

  2.2     The AS Phrase

  2.3     The TO Phrase

  2.4     The IN Phrase

  2.5     The ROUND and TRUNCATE Phrases

  3      WORKING WITH REPORTS

  3.1     Parts of the Report Procedure

  3.2     Displaying the Report Procedure

  3.3     Designing a Report

  3.4     How to Change a Report
    3.4.1      CHANGE Function Keys
    3.4.2      Changing the COLUMNS Section
    3.4.3      Changing the LAYOUT Section
    3.4.4      Changing the TOP Section
    3.4.5      Adding a WHERE or EXCEPT Section

  3.5     Special WHERE Sections

  3.6     Using a Report on Other Tables

  3.7     Using FILE * to Produce More Complex Reports

  3.8     ADE Report Keywords

  4      WORKING WITH VERBS

  4.1     Making Verbs that Use Other Verbs

  4.2     Making Verbs that Use Reports

  4.3     Using Unknown Names as Verb Steps

  4.4     Putting Comments in a Verb

  4.5     Designing One Verb To Do Different Tasks

  5      ADE COMMANDS

  ADD

  ALLOW

  APPEND

  ASK

  BACKUP

  BREAK

  CALCULATE

  CHANGE

  COMBINE

  COPY

  DIVIDE

  ENTER

  ERASE

  EXIT

  GET

  GRAPH

  HELP

  LIST

  MAKE

  MERGE

  MOVE

  MULTIPLY

  NAMES

  OUTLINE

  PICK

  REMARK

  RENAME

  SAVE

  SET

  SORT

  SUBTRACT

  TALLY

  TOTAL

  TRAIN

  UPDATE

  A   ADE Size Limits

  B   TERMINAL INFORMATION

  B.1     Starting ADE

  B.2     Stopping and Restarting the Terminal Display

  B.3     Resetting Terminal Page Width

  B.4     Using ADE on DECmate I (VT278)

  B.5     ADE Function Keys on a VT52

  C   Storage and Protection

  C.1     Inside ADE

  C.2     Outside ADE

  C.3     How ADE Protects your Data

  D   ADE File Descriptions

  D.1     Internal ADE Files

  D.2     External ADE Files

  E   ERROR MESSAGES

  FIGURES

  5-1        ADE Commands Using Optional Phrases

  B-1        ADE Function Keys on VT52 Terminal

  B-2        VT52 Keyboard

  TABLES

  3-1        CHANGE Function Keys

  5-1        Summary of ADE Commands by Functions

  5-2        CHANGE Function Keys

  5-3        ENTER Function Keys

  A-1        Maximum Size Limits

  B-1        System Terminal Information