;DBASE 

Information   about  your  dBASE II  system can  be  obtained  by 
typing HELP and the name of a dBASE II command or HELP and any of 
the following key words. 

A  - FULL SCREEN     
B  - VIDEO
C  - INSTALL
D  - DBASE TERMINOLOGY
E  - BRIEF HELP
F  - LIMITS
G  - ERRORS



:A     
FULL-SCREEN CURSOR MOVEMENT CODES -- ALL COMMANDS

ctrl-X moves cursor DOWN to the next field (also ctrl-F)
ctrl-E moves cursor UP to the previous field (also ctrl-A)
ctrl-D moves cursor AHEAD one character
ctrl-S moves cursor BACK one character
ctrl-G deletes character under cursor
<Rubout> or <DEL> deletes character to left of cursor
ctrl-Y blanks out current field to right of cursor
ctrl-V toggles between overwrite and INSERT modes
trl-W save changes and returns to "." prompt

IN EDIT MODE

ctrl-U toggles the record DELETE mark on and off
ctrl-C writes current record to disk and ADVANCES to next record
ctrl-R writes current record to disk and BACKS to previous record
ctrl-Q ignores changes to current record and returns to "." prompt
ctrl-W writes all changes to disk and returns to "." prompt

IN BROWSE MODE

ctrl-B pans the window RIGHT one field
ctrl-Z pans the window LEFT one field

IN MODIFY MODE

ctrl-T DELETES current line, moves all lower lines up
ctrl-N INSERTS new line at cursor position
ctrl-C scrolls down a half page
ctrl-W writes all changes to disk and returns to "." prompt
ctrl-Q ignores all changes and returns

IN APPEND MODE

<enter> terminates APPEND when cursor is in first position of 
        first field 
ctrl-W writes record to disk and  moves to next record
ctrl-Q ignores current record and returns to "." prompt

CONTROL KEY STROKES OPERABLE WHEN NOT IN FULL SCREEN

ctrl-P toggles your printer ON and OFF
ctrl-R repeats last executed command
ctrl-X clears the command line without executing command
ctrl-H backspace
ctrl-M emulates a carriage return
ctrl-S starts/stops CPU operation 
:B	
VIDEO

Your KAYPRO has a variety of video attributes including reverse 
and half intensity, blinking, underlining and cursor off.  In-
structions for using these are found in you User's Manual.  In
the meantime, we've included two examples of the possibilities
with your dBASE II system.  One program, REV-ON will turn on
half-intensity reverse video and the other, REV-OFF, turns it
off.  To use, type:

                    . DO REV-ON  
                          or
                    . DO REV-OFF

at the dBASE II (.) prompt.
:C	
INSTALL

In  order to use dBASE II's Full-screen  editing  facility,  your 
terminal must be properly installed.  Many dBASE formats are pre-
installed.  If  yours is not your screen will appear jumbled when 
you  attempt to perform such full screen operations as APPEND  or 
EDIT.  To correct this you must install dBASE II by  running  the 
dBASE  II installation  program,  INSTALL.COM,  called from  your 
system as INSTALL.  Since you may diagnose your terminal's status 
at  any time by running STARTUP.PRG (called from the dBASE II "." 
prompt by entering the command DO STARTUP),  you would be wise to 
use it before attempting to INSTALL dBASE II.   It will tell  you 
if  you  need to run the installation program,  and can  be  used 
later to check the results if you do.
:D :DBTERM1.HLP
:E	
BRIEF HELP

> ? -- displays an expression, variable, or field. 
> ??  --  displays an expression list without a  preceeding  line 
    feed. 
> @ -- displays user formatted data on screen or printer.
> ACCEPT -- allows input of character strings into memory vari-
       ables.
> APPEND -- append information from  another dBASE II database or 
       files in Delimited or System Data format. 
> BROWSE -- full screen window viewing and editing of database.
> CANCEL -- cancels command file execution.
> CHANGE -- Non-Full-Screen edit of fields of database. 
> CLEAR -- closes databases in  use and releases  current  memory 
       variables.
> CONTINUE -- continue the searching action of a LOCATE command.
> COPY -- creates a copy of an existing database. 
> COUNT -- counts the number of records in file which  meet  some 
       criteria.
> CREATE -- creates new database.
> DELETE -- deletes a file or marks records for deletion.
> DISPLAY -- display files, database records or structure, memory 
       variables, or status. 
> DO -- executes command files or structured loops in same.
> EDIT -- initiates edit of records in a database.
> EJECT -- ejects a page on the printer.
> ELSE -- alternate path of command execution within IF.
> ENDCASE -- terminates a CASE command.
> ENDDO -- terminates DO WHILE command.
> ENDIF -- terminates an IF command.
> ENDTEXT -- terminates a TEXT command.
> ERASE -- clears the screen.
> FIND -- positions to record corresponding to key in index file.
> GO or GOTO -- positions to specific record or place in file.
> HELP -- access help file overview or specific help file entry. 
> IF -- allows conditional execution of commands.
> INDEX -- creates an index file.
> INPUT -- allows input of expressions into memory variables.
> INSERT -- insert new record in database.
> JOIN -- joins output of two databases.
> LIST  -- lists files,  database records  or  structure,  memory 
       variables, and status.
> LOCATE -- find a record that fits a condition.
> LOOP -- skips to beginning of DO WHILE command.
> MODIFY -- create and/or edit command file or  modify  structure 
       of existing database.
> NOTE or * -- allows insertion of comments in command file. 
> PACK -- erases records marked for deletion.
> QUIT -- exits dBASE and returns to operating system.
> READ  -- initiates full-screen editing of formatted  screen  by 
       accepting input into variables accessed with @ GET. 
> RECALL -- erases mark for deletion.
> REINDEX -- update existing index file.
> RELEASE -- eliminates unwanted memory  variables  and  releases 
       memory space.
> REMARK -- permits display of any characters.
> RENAME -- rename a file.
> REPLACE -- change information in record(s) or  entire  database 
       field by field.
> REPORT -- format and display a report of information.
> RESET - reset operating system after placing new disk in drive.
> RESTORE -- retrieves memory variables stored in MEM file.
> RETURN -- ends a command file.
> SAVE -- copies current memory variables to disk file. 
> SELECT -- switches between USE files in PRIMARY  and  SECONDARY 
       areas.
> SET -- sets dBASE control parameters.
> SKIP -- position forwards or backwards in database.
> SORT - write copy of database sorted on one of the data fields.
> STORE -- creates memory variables.
> SUM -- compute and display the sum of database field(s).
> TEXT -- allows output of block of text from a command file.
> TOTAL -- creates summary copy of database combining information 
       from specified fields of records meeting some criteria.
> UPDATE -- allows batch updates of a database.
> USE -- specifies  database to USE until  next  USE  command  is 
       issued.
> WAIT  -- suspends  command file  processing  until  user  input 
       received.
:F  	
LIMITATIONS AND CONSTRAINTS

number fields/record                   32 max
number chars/record                  1000 max
number records/database             65535 max
number chars/cstring                  254 max
accuracy numeric fields             10 digits
largest number            1.8 x 10**63 approx
smallest number          1.0 x 10**-63 approx
number current memvars                 64 max
number chars/command line             254 max
number <exp>s in SUM command            5 max
number chars in REPORT header         254 max
number fields in REPORT                24 max
number chars in index key              99 max
number of pending GETS                 64 max
number of files open at one time       16 max
length of .PRG file                 unlimited
:G	
ERRORS

BAD DECIMAL WIDTH FIELD -- Re-enter decimal part of field defin-
    ition.
    
BAD FILE NAME -- Syntax error in filename.

BAD NAME FIELD --  Redefine field name while in CREATE.

BAD TYPE FIELD -- Must be C (character), N (numeric), or
    L (logical).

BAD WIDTH FIELD -- Redefine size of data field between 1 and 255.

 *** BEYOND STRING -- Rewrite substring ($) with correct parameter.

CANNOT  INSERT - THERE ARE NO RECORDS IN DATABASE FILE -- Use the 
    APPEND command instead.

CANNOT OPEN FILE -- Check the existence or integrity of MEM or 
    HEX file.

COMMAND FILE CANNOT BE FOUND -- Check spelling and default drive.

DATA  ITEM NOT FOUND -- Rewrite REPLACE command,  or  check  file 
    structure for correct field name.

DATABASE  IN  USE  IS NOT INDEXED -- FIND is  permitted  only  on 
    indexed databases.

DIRECTORY IS FULL -- The operating system's directory cannot hold 
    anymore files.

DISK IS FULL -- No space left on disk.   Use DELETE FILE to erase 
    some unneeded files.

END  OF FILE FOUND UNEXPECTEDLY -- The database in USE is not  in 
    the correct format. dBASE isn't sure that file is a DBF file.

"FIELD" PHRASE NOT FOUND -- Rewrite CHANGE command line.

FILE ALREADY EXISTS -- Delete the unwanted file before RENAME.

FILE  DOES NOT EXIST -- Use DISPLAY FILE LIKE *.* to be sure  the 
    file exists. 

FILE  IS  CURRENTLY OPEN -- Type a USE or CLEAR command to  close 
    the file.

FORMAT FILE CANNOT BE OPENED -- Check the integrity of FMT file.

FORMAT FILE HAS NOT BEEN SET -- Set the appropriate FMT file.

ILLEGAL DATA TYPE -- SORT cannot sort on a logical field.

ILLEGAL GOTO VALUE -- Record addressed must be > 0 and < 65535.

ILLEGAL  VARIABLE  NAME  -- Only  alphanumerics  and  colons  are 
    allowed  in variable and field names.   Redefine variable  or 
    field name.

INDEX DOES NOT MATCH DATABASE -- dBASE cannot match the index key 
    with the database.  Try another index file.

INDEX FILE CANNOT BE OPENED -- Check spelling or index the data-
     base.

JOIN  ATTEMPTED  TO GENERATE MORE THAN 65,534 RECORDS -- The  FOR 
    clause  allows too many joined output records.  Make it  more 
    stringent.

KEYS ARE NOT THE SAME LENGTH -- UPDATE command requires identical 
    keys.

MACRO IS NOT A CHARACTER STRING -- Variables expanded by a  macro 
    (&) must be character (C) in content.

MORE THAN 5 FIELDS TO SUM - SUM is limited to 5 fields at a time.

MORE THAN 7 INDEX FILES SELECTED -- Maximum number of index files 
    open is seven.  Fewer will give faster performance.

NESTING  LIMIT  VIOLATION  EXCEEDED -- Cannot have more  than  16 
    command files open at once.

NO EXPRESSION TO SUM -- SUM command needs a numeric expression to 
    sum.

NO "FOR" PHRASE -- Rewrite JOIN command with correct syntax.

NO "FROM" PHRASE -- Rewrite UPDATE command with correct syntax.

NO FIND - More a diagnostic than an error message. dBASE couldn't 
    find the key. Record # has been set to 0.

NON-NUMERIC EXPRESSION -- SUM command needs a numeric  expression 
    to sum.

NOT  A  dBASE II DATABASE -- DBF file opened was not  created  by 
    dBASE.

"ON"  PHRASE  NOT FOUND -- Rewrite  UPDATE or INDEX command  with 
    correct syntax.

OUT  OF MEMORY FOR MEMORY VARIABLES -- Reduce the number or  size 
    of memory variables.

RECORD  LENGTH EXCEEDS MAXIMUM SIZE (OF 1000) -- Reduce  size  of 
    some fields or create a second database on a common key.

RECORD  NOT IN INDEX -- Index file was not updated after a record 
    was added.  Reindex the file.

RECORD  OUT OF RANGE -- Record number was called that is  greater 
    than number of records in database. If the index file is  not  
    current, reindex the file.

SORTER  INTERNAL ERROR,  NOTIFY SCDP -- Internal  error,  contact 
    ASHTON-TATE for support.

SOURCE AND DESTINATION DATA TYPES ARE DIFFERENT - Check that data 
    types are both numeric, both character, or both logical.

 *** SYNTAX ERROR *** -- dBASE doesn't understand the command.

SYNTAX ERROR IN FORMAT SPECIFICATION -- @ SAY GET PICTURE command 
    is improperly set up.

SYNTAX ERROR, RE-ENTER -- INPUT, ACCEPT, REPORT require syntacti-
    cally correct entry.  May expect a different data type.

"TO" PHRASE NOT FOUND -- Rewrite command with correct syntax.

TOO  MANY  CHARACTERS  -- (Non-Full-Screen  only.)  Data  entered 
    exceeds allotted length of field.

TOO  MANY FILES ARE OPEN -- Only 16 files of all types  (Command, 
    FMT, NDX) may be open at one time.

TOO  MANY  MEMORY VARIABLES -- There is a maximum of  64  current 
    memory variables.

TOO   MANY  RETURNS  ENCOUNTERED  -- Probably  an  error  in  the 
     structure of a command file.   Check the number and location 
     of RETURNs.

"WITH"  PHRASE NOT FOUND -- Rewrite REPLACE command with  correct 
    syntax.

UNASSIGNED FILE NUMBER -- Internal error. Contact ASHTON-TATE for 
    support.  If HELP was used,  DBASEMSG.TXT file may be missing 
    from drive.

 *** UNKNOWN COMMAND -- Check spelling.  dBASE doesn't understand 
    command.

VARIABLE CANNOT BE FOUND -- Need to create the variable, or check 
    the spelling of the field name in database structure.

 ***ZERO DIVIDE -- There was an attempt to divide a <numeric exp> 
    by zero.
