DBase2 Commands * Undisplayed comment (like NOTE) - see also REMARK ? Display expression(s) on the console @ x,y Formatted screen or printer output ACCEPT Input a character string from console APPEND Add records to the current database BROWSE Browse in database, modifying records as needed CANCEL Abort execution of a command file CHANGE Make multiple changes to database items CLEAR Reset dBASE file and memory variables CONTINUE Continue a LOCATE command COPY Copy data to another file COUNT Count the number of records that satisfy some condition CREATE Create a new database DELETE Mark specified records for deletion DELETE FILE file_name Delete a file from disk DISPLAY Show contents of data records (default=current record) DISPLAY STRUCTURE DISPLAY MEMORY DISPLAY FILES DO file_name Execute a command file DO WHILE Repeats statements while is true. DO CASE Performs the first applicable CASE that follows EDIT Alter data in the database EJECT Do a form-feed on the printer ELSE Alternate path for an IF command ENDCASE Terminates DO CASE command ENDDO Terminates DO WHILE command ENDIF Terminates IF command ERASE Clear console screen FIND Locate record in an indexed database GOTO Position to given place in a database IF Conditional execution (up to ELSE or ENDIF) INDEX Generate an indexfile and attach for USE INPUT Input from console with type checking INSERT Insert a record into the database JOIN Create a new database combining PRIMARY & SECONDARY LIST Show data records (default=all records) LOCATE Find record without using index LOOP Used inside DO WHILE, goes to ENDDO MODIFY COMMAND Modify a command file from dBASE MODIFY STRUCTURE Modify structure of a data file NOTE Comment in command file, not displayed (also *) PACK Eliminate records marked for deletion QUIT Terminate DBASE READ Perform data entry for a formatted screen RECALL Unmark records marked for deletion RELEASE Erase memory variables (to save space) REMARK Comment in command file, displayed on screen RENAME Rename a disk file REPLACE Alter data fields REPORT Prepare a report from the datafile RESET Reset CP/M after swapping disks RESTORE Reload memvars from SAVEd file RETURN Return from a command file SAVE Save all memory variables for future RESTORE SELECT Switch working areas SET Set values for option parameters SKIP [number] Move forward (or back) in the database SORT Generate a new sorted database (single key only) STORE exp TO memvar Assignment statement for memory variables SUM Compute the database sum for given fields/expressions TOTAL Generate an aggregated database UPDATE Modify with data from another database USE Opens the specified .DBF database file WAIT Wait for next keyboard character