j SŒCOMMANDCÑlSYNTAXC<ÙlDESCC<mPAGENQmLINKCTm ? ? [] Writes data to output device 30%? %? ?? [] Writes data to output device (no preceding CR/LF) 30 @ @ [SAY [USING ]] [GET [PICTURE ]Places/gets info on screen or printer 32 ACCEPT ACCEPT [""] to Gets string data to memory variable 38 APPEND APPEND FROM [FOR ] [SDF] [DELIMITED WITH ] Adds data from another data base or sequential file 39%APPEND1 %APPEND1APPEND BLANK Adds a blank record to the file 39%APPEND2 %APPEND2APPEND Allows interactive entry of one or more new records 39 BROWSE BROWSE Allows interactive display/update of data base 46 CANCEL CANCEL Cancels command file execution 47 CHANGE CHANGE [] FIELD [FOR ] Changes data base record(s) individual field 48 CLEAR CLEAR [GETS] Clears dBASE II or outstanding @...GETs 49 CONTINUECONTINUE Used with LOCATE 050 COPY (See manual for syntax) Copies data from files/data bases 51 COUNT COUNT [] [FOR ] [TO ] Counts records 55 CREATE CREATE [] Creates a new data base 57 DELETE DELETE [] [FOR ] Deletes one or more records from data base 60%DEL %DEL DELETE FILE deletes a CP/M file or data base 60 DISPLAY DISLPAY [] [FOR ] [] [OFF] Displays one or more records from data base 62%DISPLAb %DISPLAbDISPLAY STRUCTURE Displays the structure of a data base 62%DISPLAc %DISPLAcDISPLAY MEMORY Displays memory variables 62%DISPLAd %DISPLAdDISPLAY FILES [ON [LIKE ] Displays data bases or CP/M files 62 DO DO Execute a command file 64%DOb %DOb DO WHILE Begin a conditional block (ended with ENDDO) 64%ENDDO %ENDDO ENDDO Used to end a conditional block started with DO WHILE 64%DOc %DOc DO CASE Begins a set of cases 64%CASE %CASE CASE Begins an individual case in DO CASE group 64%OTHER %OTHER OTHERWISE Begins the default case in a DO CASE group 64%ENDCASE %ENDCASEENDCASE Ends the last case in a DO CASE group 64 EDIT EDIT [n] Edit one or more data base records 65 EJECT EJECT Skip printer to new page 68 ENDDO ENDDO Ends a DO WHILE... group 69 ERASE ERASE Erases all memory variables & clears the screen 70 FIND FIND or '' Finds a record in an indexed file 71 GO See GOTO See GOTO 74GOTO GOTO GOTO RECORD Sets data base pointer to specified record 74%GOb %GOb GOTO TOP Sets pointer to first record of data base 74%GOc %GOc Sets data base pointer to specified record 74%GOd %GOd GOTO BOTTOM Sets data base pointer to last record of data base 74%GOe %GOe GOTO Sets data base pointer to record indicated in memvar 74 IF IF Begins IF group 76%ELSE %ELSE ELSE Indicates statements to run if IF condition is false 76%ENDIF %ENDIF ENDIF Ends IF group 76 INDEX INDEX ON TO Builds an index of a database 77 INPUT INPUT [""] TO Gets data to a memvar 81 INSERT INSERT [BEFORE] [BLANK] Inserts one record into a data base 83 JOIN JOIN TO FOR [FIELDS ] Joins primary and secondary data base creating a new one 86 LIST (See DISPLAY) Same as DISPLAY except scope defaults to ALL 89DISPLAY LOCATE LOCATE [] [FOR ] Locates a data base record 90CONTINUE LOOP LOOP Causes immediate beginning of new loop in command files 92 MODIFY MODIFY STRUCTURE Changes a data base structure 93%MOD %MOD MODIFY COMMAND [] Modifies a command file 93 NOTE NOTE any characters A comment (usually in a command file) 95* * * any characters a comment (normally in a command file) 95 PACK PACK Removes deleted records from data base 96 QUIT QUIT [TO ] Exits dBASE 98 READ READ Instructs dBASE to read data from @...GET commands 99 RECALL RECALL [] [FOR ] Un-deletes one or more records 102 RELEASE RELEASE [] Removes specified memory variables, freeing space 106%RELEASE %RELEASERELEASE ALL Releases all memory variables 106 REMARK REMARK any characters Displays remarks on output device 107 RENAME RENAME TO Renames a data base or CP/M file 108 REPLACE (See manual for syntax) Replaces data in one or more data base records 109 REPORT REPORT [FORM ] [TO PRINT] [PLAIN] Creates a report from a data base 112 RESET RESET Tells CP/M that disks have been swapped 121 RESTORE RESTORE FROM Restores memory variables previous saved 122 RETURN RETURN Returns to caller of command file 123 SAVE SAVE TO Saves memory variables to disk 124 SELECT SELECT PRIMARY Selects the primary data base 125%SELECT %SELECT SELECT SECONDARY Selects the secondary data base 125 SET SET ECHO ON/OFF Sets display of commands 128%SET1 %SET1 SET STEP ON/OFF Sets single step mode 128%SET3 %SET3 SET TALK ON/OFF Sets display of messages from commands 128%SET4 %SET4 SET PRINT ON/OFF Sets output to printer 128%SET5 %SET5 SET CONSOLE ON/OFF Sets output to screen 128%SET6 %SET6 SET ALTERNATE ON/OFF Sets output to go to a disk file 128%SET7 %SET7 SET SCREEN ON/OFF Sets full-screen mode 129%SET8 %SET8 SET LINKAGE ON/OFF Makes sequential commands advance both data bases 129%SET9 %SET9 SET COLON ON/OFF Sets whether colons should display to border fields 129%SET10 %SET10 SET BELL ON/OFF Determines whether console alarm is sounded 129%SET11 %SET11 SET ESCAPE ON/OFF Determines whether ESC key aborts command files 129%SET12 %SET12 SET EXACT ON/OFF Determines whether search string must match longer data 129%SET13 %SET13 SET INTENSITY ON/OFF Determines if normal/inverse video is to be used 130%SET14 %SET14 SET DEBUG ON/OFF Sends debug commands to printer (if on) 130%SET15 %SET15 SET CARRY ON/OFF Determines if APPEND carries data to next record 130%SET16 %SET16 SET CONFIRM ON/OFF Determines whether cursor moves to next field automatically 130%SET17 %SET17 SET EJECT ON/OFF Sends form feed to printer if on 130%SET18 %SET18 SET RAW ON/OFF Places spaces between LIST/DISPLAY fields if on 130%SET19 %SET19 SET SCREEN ON/OFF Sets full-screen mode 130%SETb1 %SETb1 SET HEADING to Sets report heading 131%SETb2 %SETb2 SET FORMAT TO SCREEN Sets @ output to go to screen 131%SETb2b %SETb2b SET FORMAT TO PRINT Sets @ output to go to printer 131%SETb2c %SETb2c SET FORMAT TO Specifies where @ commands come from 131%SETb3 %SETb3 SET DEFAULT TO Sets CP/M default drive 131%SETb4 %SETb4 SET ALTERNATE TO Specifies alternate data base name 132%SETb5 %SETb5 SET DATE TO mm/dd/yy Sets date 132%SETb6 %SETb6 SET INDEX TO [, ...] Sets one or more index files to be used 133%SETb7 %SETb7 SET MARGIN TO n Sets printer margin 133 SKIP SKIP [+/-][] Moves data base current record pointer 134 SORT SORT ON TO [ASCENDING/DESCENDING] Sorts data o the specified field 135 STORE STORE to Sets the value of a memory variable 137 SUM SUM [,[ [TO ] [] [FOR ]Computes totals of specified field(s) 138 TOTAL TOTAL ON TO [FIELDS ] [FOR ] Creates a new data base with total values 139 UPDATE (See manual for syntax) Updates one data base with data from another 141 USE USE Specifies the current data base 143%USE %USE USE INDEX [, ...] Sets new current data base & index file(s) 143 WAIT WAIT [TO Waits for keyboard input 144 th data bases 129%SET9 %SET9 SET COLON ON/OFF Sets whether colons should display to border fields 129%SET10 %SET10 SET BELL ON/OFF Determines whether console alarm is sounded 129%SET11 %SET11 SET ESCAPE ON/OFF Determines whether ESC key aborts command files 129%SET12 %SET12 SET EXACT ON/OFF