;
Information may be obtained for any of the following by entering the 
appropriate selection:

A  - UPDATE 
B  - USE
C  - WAIT

D  - FUNCTIONS

1  - (ACCEPT > JOIN)
2  - (LIST > TOTAL)
:A   
UPDATE

> UPDATE -- allows batch update of presorted or indexed  database 
       by  drawing  information  FROM designated  database  (pre-
       sorted  on same <key>).  Keys of records in USE  and  FROM 
       databases  are compared for match.  dBASE can then ADD the 
       numeric  fields  of  the FROM  database  to  corresponding 
       fields in the USE database.  It can also REPLACE character 
       or  numeric  fields of USE database with the  contents  of 
       corresponding fields of the FROM file. 

   Syntax: UPDATE FROM <file> ON <key> [ADD <field list>][REPLACE
            <field list> or <field> WITH <field list>][RANDOM]
:B 
USE

> USE <file> [INDEX <index file list>] -- specifies the  database 
       to be used for all succeeding operations.  USE  automatic-
       ally  closes previous file in USE.   INDEX option overlays 
       the  database with an index to give it an apparent  order.  
       Other indexes named will be kept current.
:C 
WAIT

>  WAIT [TO <memvar>] -- used in command files to  suspend  dBASE 
       operation  until  keyboard input of  a  single  character.  
       WAIT  TO <memvar> will automatically store keyboard  input 
       into a memory variable, and may thus be used to direct the 
       action of a command file process. 
:D
FUNCTIONS

> @ --  @(<cstring1>,<cstring2>) -- AT function yields an integer 
       whose  value  is  the  character   number   in  <cstring2> 
       which begins a substring identical to <cstring1>.

> *  -- deleted record function evaluates as a  logical  True  if 
       current record has been marked for deletion.

> # -- record number function reports value  of  integer  corres-
       ponding to current record number. 

> !  -- !(<cstring>)  -- uppercase function yields  <cstring>  in 
       uppercase characters.

> $ -- $(<cstring>,<start>,<length>) -- substring function  forms 
       a  character  string  from the specified part  of  another 
       string.

> CHR -- CHR(<numeric exp>) -- yields the ASCII  character  equi-
       valent of the <numeric exp>.   e.g.,  ?  CHR(7) rings  the 
       bell.

> DATE() -- returns the character string that contains the System 
       Date in format xx/xx/xx. 

> EOF -- end-of-file function evaluates as True if an attempt has 
       been made to go past the last record in a database.  

> FILE -- FILE(<file>) -- existence function evaluates as a logi-
       cal  True if <file> exists on the default drive,  and as a 
       logical False if it does not.

> INT -- INT (<numeric exp>) -- integer function truncates every-
       thing to right of decimal to form an integer. 

> LEN -- LEN(<cstring>) -- length  function returns the number of  
       characters in <cstring>.  ? LEN('HELLO')

> RANK -- RANK(<cstring>) -- returns the (ASCII numeric) value of  
       the  leftmost character of <cstring>.

> STR -- STR (<numeric exp>,  <width>  [,<decimals>])  --  string 
       function  converts  a numeric expression into a  character 
       string.

> TEST  -- TEST(<exp>) -- used with  ?  and  IF,  test   function 
       determines if  <exp> is valid and parsable.  A valid <exp> 
       returns a value # 0; an invalid <exp> a value of 0.

> TRIM -- TRIM(<cstring>) - trim function removes trailing blanks 
       from <c-string>.  ? TRIM(FIRST) + ' ' + LAST.

> TYPE -- TYPE(<exp>) -- function yields a  one-character  string 
       that  contains  a 'C','N','L',  or 'U' if the <exp> is  of 
       type Character, Numeric, Logical, or Undefined. 

> VAL  -- VAL(<cstring>) -- value function converts  a  character 
       string made of numerals into a numeric expression. 

:1 :DBTERM1.HLP
:2 :DBTERM2.HLP
