.PO 15
.OP

                           
                -   


                          
                O   DBASE II 
                   



      DBASE II
      ASSEMBLY-LANGUAGE
      RELATIONAL DATABASE MANAGEMENT
      SYSTEM
              ASHTON-TATE, 1981, 201P, USA



  :      
                    DBASE II,     CP/.

                       ZIP,  
                           
                      ,    DBASE II
                      .




                              ..
                              20.02.84






                                 1984

























   
     DBASE II

                                 

1.0  DBASE...........................................  2
2.0  ............................................  3
3.0  DBASE...................................................  4
          3.1   ....................................  4
          3.2  ........................................  5
          3.3  .....................................  5
          3.4   ...............................  6
          3.5   ..............................  6
          3.6  .....................................  6
          3.7  .....................................  6
4.0 .....................................................  6
          4.1 .............................................  7
          4.2 ............................................ 11
5.0 .............................................. 14

6.0    ,   DBASE..... 14
7.0  ................................................. 15
8.0    ......................................... 17
9.0 ....................................................... 18
          9.1   ...................... 18
          9.2  ................................... 21

          .............................................. 81
          /  ............................... 81
          / ......................................... 86
          /  ............................. 88
          /  .................................. 89





























.PN 1


                       DBASE II :

              DBASE  II             

. ,        DBASE II, , 

,   ,    DBASE  ,  

     .
        ,  ASHTON-TATE    

   ,   ,        

 DBASE II.
         /APPLICATION  JUNCTION/       

,        

DBASE    ,   ASHTON-TATE     . 

ASHTON-TATE     ,   DBASE.
              

ASHTON-TATE       ,   

. 
   -RUNTIME      :   DBASE  "RUNTIME"  /" 

"/  ,       ,        

   ,       

 DBASE II. RUNTIME       

        .  RUNTIME     

  ,    DBASE II.
     ,      ,       

.  ASHTON-TATE        - 

      DBASE.  ,     

    ,  ,      

   ,   DBASE.

                                

                                ASHTON-TATE





























1.0    DBASE.

             DBASE,     

  DBASE  /,   ,    /     

   .    ,      

,       /,       

 "",   ":",     /   

  :

       DBASE

               

  :

       ENTER DATE AS MM/DD/YY OR RETURN FOR NOME:
       / ,  //   ,  :/

       -  ,       

  ,        
REPORT     ,       . 

    .
    :      29       
                                1900  2100.
                

   / /.

   :
1,1,81
02 02 82
3/17/83

      :
 ***   DBASE   VER2.XXX***
 .
      DBASE,   ,  

DBASE    .    DBASE,    ,   

    :  ,     

,     . DBASE  

   ,      -   .   

DBASE      ,         

      ,       .     

       ,    , 

       .   DBASE    , 

      ,    ,      

              

,   .

   :
 .DISPLAY MEMORY
 ***UNKNOWY COMMAND***
 DISPLAY MEMORY                       
 CORRECT AND RETRY? Y             , 
 CHANGE FROM :PR                    PR
 CHANGE TO   :PL                   PL
 DISPLAY MEMORY                    ,
 MORE CORRECTIONS ?/ /  =  

 .STORE(2+2 TO X
 ***SYNTAX ERROR***
 ?                                  (2+2

.PO 5
 STORE (2+2 TO X
 CORRECT AND RETRY? Y
 CHANGE FROM :+2
 CHANGE TO   :+2)
 STORE(2+2) TO X
 MORE CORRECTIONS ?N                 
 4                                 

 .SUM TO X
 NO EXPRESSION TO SUM              :  SUM  
 SUM TO X
 CORRECT END RETRY ?N               ,   

           :

DBASE < >

   DBASE   ,     

  < >       

.            

 QUIT  DBASE.

 

CTL-P -    /.   SET PRINT/;
CTL-U -   ;
CTL-X -    /    
        ;
RUBOUT-    ;
CTL-H   / BACKSRACE/ -    ;
ESC    -       ,       

.     ,   DISPLAY,   COUNT,  DELETE,  INPUT,  LIST,  LOGATE, 

RECCALL,REPLAGE,  SKIP,   SUM. K  , ESC      

ACCEPT,  INPUT,  REPORT  //   WALT.      ESC   

         -  /./
     ,  DBASE    ESC   

   .
 :          ---
                              SET ESCAPLE OFF.

2.0    .

    ,  DBASE   ,    

   :
/  ,   8080  Z80;
/  48  ( ) ,   CPI,  DBASE      

     400.
    :   ,  APPELE, HEATH I NORTHSTAR,
                ,  48 , -   CP/M;
/   / / 1.4  2./;
/         ,     

/ /      /;
/   CRT //       / 

CRT  24-   80- /,     , 

   ;
/      
   /  /.





.PO 15
3.0    DBASE.

      ,         A,       

         ,          

.         .
          6- ,      

    DBASE,   DBASE. 
     DBASE    /,     8- 

     3- .
      ,       DBASE. 

   ,      ,      

      DBASE  ,          

.  ,         DBF     

,             

.

                               -.DBF
                                  -.MEM
                               -.CMD
                        -.FRM
                         -. 
                               -.NDX
                               -.FMT

     ,   /,      

   DBASE.  ,        -  , 

    ,  DBASE   , 

  .       ,     

   ,     DIGITAL RESEARCH "CP/M 

USER'S GUIDE".

3.1      /.DBF/.

      ,     .    

DBASE        65535-  .   

       .  

   32-  .       

    .     :
 *   
 *     
 *   
 *    

         -       10-  .     

,           DBASE,         

    .             -

 / /. ,      ,  

     .

    :

123456789
BC:DEF
A:B:C:D:E
ABCD:          ,    
ABC,DEF        ,   .



      - DBASE    ,      

     .     :       

.PO 5
/'BCD'/,    /2  5*18/,   /TRUE/FALSE - 

//.
     -     //,   

 ,      .
              1-   254- 

.             

.       .    ,    

           

 .
      ,       

 ,    ,   .
               ,   

      / ,     

USE  ,   USE ///.
          .
   (.  SELECT  JOIN).

3.2     (.).

         ,    

  ,    .     ,   

      64- .
              .   

,        USE         

.        ,   

,     /.  .5/   .   

  ,               

  ,       .
     SAVE         ,   

 RESTORE        .

3.3     /.CMD/.

          DBASE.
           

  ,              

    .
                     

  /  ,       DBASE   

 /     MODIFY COMMAND.
         DBASE,  ,    

,    /CREATE, INSERT, APPEND,  

  /        

 .
       , . .     

 DO,    .   ,    

 ,  DBASE        16 .
   ,       USE,    15     

 .       /, 

SORT    ,  REPORT,INSORT,COPY,SAVE,RESTORE  

PACK    /.
   ,      SORT      

 ,       13    

  /..    USE,       SORT    13   

=16/.    ,       RETURN  

  ,          ,     

        .





.PO 15
3.4      /.FRM/

    REPORT    ,      

 .        , 

,      .      

  DBASE,   KAK        REPORT.       

         ,  , 

      .

3.5      /./.

                    "SET 

ALTERNATE TO"< >  "SET ALTERNATE ON" (.  SET,   

  ).    ,    COPY    AEND   

    /./,        SDF  / 

 /  DELIMITED.

3.6     /.NDX/

        INDEX  DBASE.    

           .     

 DBASE,         . 

(.  INDEX    ).

3.7     /.FMT/.

          "@"     "*".   

    "SET  FORMAT TO <  >     

    READ.     /    

  /,             

             MODIFY 

COMMAND,       .  "@"  

"*"     ,    .

4.0   

       DBASE           , 

       ,        

.  , "2+2"  ,     

   "4".        

    "ABS+DEF",           

"ABSDEF"  /   /    "1>2"     

     ".F." //.
     DBASE      :
     *    
     *  
     *    //
     * 
     * 

     -    DBASE      ,   

    .       DBASE,       

   ,   .       

          

.
               STORE,   RESTORE, 

COUNT,  SUM,  WAIT,  ACCEPT  INPIT.     

.         :
     *  
     *  


.PO 5
     * 

     -  / /    ,   

      .  ,  I,  "ABC"    .. 

  ,             

    ,     .  

  ,         ,       

  /   ,      , 

   /.    ,          , 

   :   ,    /   

"", "", "" /   //  TRUE (".T.").
                 ('), 

  (")     ([ ]).  (??? I,I)
          "",     

     .
   , 'ABC IDEFI GHF'  'ABC'DEF'GHI I    

,     'ABC'DEF'GHI I - .
      ///      "F","T","N", 

  "N"       / /FALSE/      /NO/   

"","","Y"    "Y"    /  /TRUE/    

/YES//.

4.1   .

        ,       

         ,       

         .    DBASE     

     :  ,    .      

   ,   .

  :
     INT(< >)

                 

/  /,      .  

 INT     .

 :
 . ? INT (123.456)
 123
 .STORE 123.456 TO X
 123.456
 . ? INT (X)
 123

  

#
            ,   

  .
:
 .?#
 4       /,          /USE/   

            N4/
 .SKIP
 .?#
 5
  
STR(< >, <>,(< >))
             . 

    STR          <>.   

.PO 15
  <  >,         

 .      , 

 .
:                 

,    .
               
:
 .? STR(123.456,9,3)
 123.456

 : 
$(< >,<>,<>)
              

.             

<>  ,      ,     

      <>     <>  .<>   

<>   ,   .
     <>,        <  >   

   <>      <>
   <  >  ,      

   ,  .   .
:                    

,    .
  :
  .?$( 'ABCDEFGHI',3,3)
  CDE
  .STORE 3 TO M
  3
  .STORE 3 TO N
  3
  .?$( 'ABCDEFGHI' ,M,N)
  CDE
  .$?( 'ABCDEFGHI' ,6,7)
  FGHI
  . DISRLAY FOR '8080 ' $ TITLE
  
    
VAL (< >)
           ,     

,    1-  .       

  .       ,  

     ,           VAL,   

      .
           "&"
/ 5.0. /.
"&"          /      /,    

 .
:
 .? VAL('123')
 123
 .? VAL ('123')
 123
 .? VAL('123.456')
 123
 .STORE'123.456' TO NUM
 123.456

 .? 14+&NUM
 137.456



.PO 5
 

LEN (< >)

      ,     

   .

:
 .STORE 'ABC'  STRING
 .?LEN(STRING)
 3
  
 =
-  ,    .TRUE.,     

  ,  .FALSE.,  .

:   
 .?=
 ..     /,       /USE/
                 DELETE/
        
  

 EOF
   -  ,    .TRUE.,
      ,    USE /    

     /.

:

 ?EOF
 .F.      /,      /USE/
                 /
 .GTO BOTTOM
 .? EOF
 .SKIP
 .? EOF
 .T.

  

L (<1-  >,<2-  >)
        ,        

  <2-  >,   ,  

  <1-  >.   1-      2- 

<       .  :   

    "S",    ,   ,    1- 

      2-         "  1- 

   2- ".

:
 .?  ('DEF' ,'ABCDEFGHI')
  4

  
! (< >)
        ,      

   ,     / /.




.PO 15
 :
 .?!('ABS')

    
R(< >)

              ASCII,      

  .   ,      13,    CHR(13) 

   ASCII  .
       ,          

          ,       

  .

 :
 .?'BCD'+CHR(13)+' '
 ABCD

 
DATE()

       ,      

  /DD/YY.       8.     

   ,    ,   -  / , 

  ,   ,   "DATE"/.
    DBASE       DBASE    

 ,   SET DATE TO.

 :

 .?DATE()
 08/18/81
 .STORE DATE () TO MEMVAR
 08/15/81
 .SET DATE TO 4 1 82
 .?DATE()
 04/01/82

  .
FILE(< >)
    -  ,    .RUE.,  < 

>    ,  .FALSE.,    

.
 :

 .?FILE('TRACE')
 .T.
 .USE TRACE

  
TYPE(<>)

       ,   "",  "N" 

  "L",     <>  ,  ,    , 

  .

 :
 .STORE I TO X
 .? TYPE(X)
 N



.PO 5
 TRIM

TRIM(< >)

    TRIM     ,   ,    

,        .
      :                   

 DBASE.

 :
 .STORE 'ABC' TO S
 .? LEN(S)
 .G
 .STORE TRIM(S) TO S
 .? LEN(S)
  3

4.2   

      4         :    ,     

//,           .   

     ,       

 .
     ,    ""         

.    ,               

,      ,       

,        DBASE.

 .STORE 3 TO A
 3
 .STORE '3' TO B
 3
 .? A+B
 ***SYNTAX ERROR ***
 ?
 ? A+B
 CORRECT AND RETRY (Y/N)?      /   Y/N/
 
       ,             

  ;        ,  

 ,          ASC II 

  33.     ,   

,                     . 

               

:

 .? A+VAL(B)
 6
 "3"       .

  /  /

     + = 
     - = 
     * = 
     / = 
     () =    





.PO 15

 :

 .? (4+2)*3             ,
 18                     .
 .? 4+(2*3)
 10

  /  /

     < =   
     > =              
     = =  
     <>=   
     <= =    
     >= =    
     S  =      /,          

,   ASB  TRUE //,         

     /.
                           

.? 'ABC'C,ABCDEFGNI'               
 ..                               S
 .?  'WSD'S'GHIKL'
 .F.
 .DISRLAY  FOR '8080' STITLE         '8080' =   

                                 TITLE   


   /  /
   .OR. =  ""
   .AND. =  ""
   .NOT. =  "" / /

:

 .STORE T TO A
 .T.
 .STORE 'F' TO B
 .F.
 .?  .R. B
 ..
 .STORE. OT. B TO C
 ..
 .? A .AND. C
 ..

















.PO 5
 
,     /   
                                            /

+=  
-=     

 :
 .STORE 'ABCD' TO A
 ABCD
 .STORE 'EFGH' TO B
 EFGH
 .? A+B
 ABCD EFGH
 .STORE 'ABCDE' TO A
 ABCDE
 .STORE '1234 67' TO B
 1234 67
 .? A-B
 ABSDE1234 67

 

    ,  ,      , 

 ,     ,   ,    

  .       

     .      /1,  2,  

. ./,    ,  - .

 :
 .? 4+2*4
 10
-----------------------------------------------------------------------------
              !             ! 
           ! ,            ! 
               !    ! 
                         !                !
-----------------------------------------------------------------------------
1/  ,       !  , !    .NOT.
                  !                        !
                         !                        !
2/  + ,-          ! , $           !     .AND.
                         ! / /  !
                         !                        !
3/ *,/                   ! +,- //    !     .OR.
                         !                        !
                         !                        !
4/ +,-                   !                        !
                         !                        !
                         !                        !
5/              !                        !
------------------------------------------------------------------------------










.PO 15


5.0 

     ,        /&/,     

      ,  DBASE   /&/   

     ,       

  .        

          .
          .   

        .     

             /   / 

    .
          , 

      .      

,    .
            ,   

        .

 :

 .ACCEPT "   "  DR

 USE &DR:DATAFILE        /    B:DATAFILE,  
                             ACCERT   ""/

 .STORE 'DELETE RECORD' TO T
 &T 5                    /    :
                          DELETE RECORD 5/

        .

6.0       DBASE.

   DBASE            ,          

   DBASE /,  BASIC, FORTRAN, PASCAL/   

 ,      .
     APPEND         ASCII 

/          /,   

   ,             / 

   SDF /  /.  ,  

COPY      ASCII,      

SDF.      ,      ,     

 SDF  DELIMITED,  ..
                          

  .           

      .  DBASE     

/APPEND/     /COPY/  ,       DELIMITED 

  .     DELIMITED,   

 SDF.
              

  ,   -   ,  APPEND 

      .    COPY       

,      ,         WITH 

 DELIMITED.        

 .
       ,    ","     WITH   

  COPY.              

          .    -,   

        -  .


.PO 5

 :

 .USE < >.DBF
 .COPY TO < >. DELIMITED WITH"

 .USE < >.DBF
 .APPEND FROM < >.DAT SDF


7.0  

         DBASE   "   

    .      . 

      DBASE              

 ,    ""   

 .         . 

   ,     

,  "   9.0

   -            

  :

*CREATE        -      ;
*COPY          -       ;
*MODIFY        -    ;
*REPORT        -    ;
*SAVE          -      
                  ;
*INDEX         -   ;
*REINDEX       -    ;
*JOIN          -  " 2-  ;
*TOTAL         -     .

    -         

:

*APPEND        -     ;
*CREATE        -     ;
*INSERT        -    ;

  -       :

*CHANGE        -   ;
*BROWSE        -       ;
*DELETE        -    ;
*EDIT          -      ;
*PACK          -  ,   ;
*REPLAGE       -    ;
*READ          -   ,  
                      ;
*UPDATE        -     .

       -        

,    :

*E              -         

                   /CRT/;
*BROWSE         -      19-       

                  ,     ;


.PO 15
*COUNT         -      ,          

                     ;
*DISPLAY       -    ,   ;
*READ          -       
                      ;
*REPORT        -       ;
*SUM           -         
                   ;
*?             -     .

   -       

    :

*CONTINUE      -        
                 ,   LOCATE;
*FIND          -     ,       

                  ;
*LOCATE        -  ,   ;
*SKIP          -     .

      -          

  :

*APPEND        -   DBASE     
                  /SDF/;
*DELETE        -  ;
*DO            -   ,    
                  ;
*RENAME        -   ;
*SELEKT        -    , 
                   /USE/;
*SORT          -    ,    
                    ;
*USE           -    ,      

                     ,     
                  USE.

     -    

 :

*ACCEPT        -      ;
*COUNT         -     ;
*DISPLAY       -      ;
*INPUT         -     ;
*RESTORE       -    ;
*SAVE          -     ;
*STORE         -     ;
*SUM           -      ;
*WAIT          -      
                   .

      -            

  :

*ACCEPT        -       ;
*CANGEL        -    ;
*DO            -       
                      ;
*IF            -    ;
*ELSE          -     
                  IF;

.PO 5
*ENDDO         -   DO WHILE;
*ENDIF         -   IF;
*INPUT         -      ;
*LOOP          -     D WHILE;
*MODIFY        -    ;
*RETURN        -   ;
*SET           -    DBASE;
*WALT          -    .

    -     

,       /CRT/:

*EJECT         -      LIST;
*ERASE         -    /CRT/.


8.0    .

                       

 :

CTL-E,A   -      ;
CTL-X,F   -      ;
CTL-S     -       ;
CTL-D     -        ;
CTL-Y     -    ;
CTL-V     -      ;
CTL-G     -    ;
RUBOUT    -     ;
CTL-Q     -                  

                DBASE;                

            .

      EDIT :

CTL-U     -      :
                 ;
CTL-R     -          
             ;
CTL-C     -          
             ;
CTL-W     -         
CTL-O         /CTL-O  SUPERBRAIN/.

   MODIFY :

CTL-N     -         , 
                 ;
CTL-T     -   ,   ,   
              ;
CTL-C     -   ;
CTL-R     -   ;
CTL-W     -        
CTL-O       /CTL-O  SUPERBRAIN/;
CTL-Q     -     .
CTL-Q     - NQSYEQRBK_ER B[UND AEG QNUP@MEMH_ HGLEMEMHI.
