FOXBASE command set

Command brief description

? Show expression strings in the next line
?? Display expression strings in the current row
@... Display the data on the screen or print it on the printer in the User-Defined Format.
Accept assigns a string to the memory variable
Append records to database files
Append from adds records to database files from other database files
Average calculates the arithmetic mean value of a numeric expression
Browse full-screen display and editing of database records
Call binary files in the running memory
Cancel terminates program execution and returns the dot prompt
In the multi-choice statement, specify a condition
Change edits specified fields and records in the database.
Clear the screen and move the cursor to the upper left corner of the screen
Clear all close all open files, release all memory variables, select workspace 1
Clear fields clear the field table created using the set fields to command
Clear gets releases any variable of the current get statement from the full-screen read.
Clear memory clear all current memory Variables
Clear program clear program buffer
Clear typeahead clear Keyboard Buffer
Close to close a file of the specified type
Continue directs the record pointer to the next record that meets the conditions specified by the locate command.
. An error occurred if no locate exists.
Copy to copy the used database file to another library file or text file
Copy file copy any types of files
Copy structure extened to the structure of the current library file as a record to create a new library file
Copy structure to copy the structure of the library file in use to the target Library File
Count: calculates the number of specified records in a given range.
Create defines a new database file structure and registers it to the directory.
Create from creates a new library file based on the database structure file
Create label creates and edits a label format file
Create report create object edit a Report Format File
Delete adds the delete mark to the specified record.
Delete file: delete an unopened file.
Dimension defines an array of memory Variables
DIR or directory: list the file directories on the specified disk.
Display displays records and fields of an Open Library File
Display files viewing files on the disk
Display history view executed commands
Display memory display the current memory variable on the page
Display status: displays the system status and system parameters.
Display Structure displays the structure of the current library file
Do executes the FOXBASE program.
Mark of the start of multiple judgments in the do case program
Sign of the start of a loop in the do while Program
Edit edit database field content
Use the eject command to change the printer page. Set the values of prow () and pcol () functions to 0.
Else provides another condition in the IF... endif structure to select the route
End multiple judgments in endcase
Indicates the end of a loop in the enddo program.
Endif determines the end mark of the IF... endif structure of the body.
Erase deletes a specified file from the directory
Exit: Execute the exit loop command in the loop body.
Find moves the record pointer to the first record containing the same index keyword as the given string.
Flush clear all disk access Buffers
Gather from assigns the value of the array element to the current record of the database.
Go/goto move the record pointer to the specified Record Number
Help activates the Help menu and explains FOXBASE + commands.
If you specify the judgment condition in the IF... endif Structure
Index generates an index file based on the specified keyword.
Input accepts an expression typed on the keyboard and assigns the specified memory variable
Insert inserts a record at the specified position
Join combines specified records and field groups from two database files into another database file
Keyboard: Enter the string in the Keyboard Buffer
Label from prints tags using the specified label format file
List lists the records and fields of database files
List Files list the files in the current directory of the Disk
List history list of executed commands
List memory lists the current memory variables and their values
List status lists the current system status and system parameters.
List structure lists the database structures of the currently used database
Load transfers the assembly language program to the memory from the disk
Locate moves the record pointer to a real record for a given condition
Loop skips all statements between loop and enddo in the loop body and returns to the first line of the loop body.
Menu to activate a set of menus defined by the @... prompt command
Modify command enters the word processing status of FOXBASE + system, and edits an ASCII text file (if the specified file name is suffixed with. PRG, edit a FOXBASE + command file)

Modify file: edit a common ASCII text file Modify label creates and edits a label (. LBL) file. Modify Report: Create and edit a report format file (. FRM) Modify structure modify the structure of the currently used library file Note/* Insert a line comment in the command file (Program) (this line is not executed) On is executed according to the specified transfer procedure In do case, otherwise specifies conditions other than the given conditions. Pack permanently deletes records with deleted tags Parameters refers to the memory variable in which the sub-process receives parameters passed by the main process. Private defines the attribute of the memory variable as local. Procedure indicates the start of a sub-process. Public defines the memory variable as global. Quit closes all files and exits FOXBASE + Read activates the get statement and accepts the data entered in the get statement. Recall recovery: Use Delete to add deleted records Reindex re-create the original index file in use Release: current memory variables and assembly language subroutines Rename Replace the original content in the database field with the specified data Report Form display data report Restore from recovering memory variables from memory variable files (. MEm) Restore screen loads the previously stored screen image Resume enables the paused program to continue execution from the paused breakpoint Retry returns the calling program from the currently executed subroutine and re-executes it from the original calling line Return end subroutine, return the calling program Run /! Execute an operating system program in FOXBASE + Save to save the current memory variable and its value to the specified disk file (. MEm) Save screen stores the content displayed on the current screen in the specified memory variable Scatter moves the data in the current database file to the specified array Seek moves the record pointer to the first record containing the index keyword that matches the specified expression Select select a workspace Set FOXBASE + Control Parameters Set alternate on/off settings transfer/do not send output to a file Set alternate to create a file to store the output Set bell on/off Set Carry On/Off to set the last record to copy/not to the added record Set century on/off: set date type variables to/from Century prefix Set clear on/off: Set screen information./cannot be cleared. Set color on/off set color/monochrome display Set color to set the screen color Set confirm on/off is set in full-screen editing mode, and automatically jumps to the next field if required/Not required Set console on/off settings to transfer/not to the screen Set date: set the format of the date expression Set Debug on/off settings send/do not send Echo output to the printer Set decimals to set the number of decimal places to be displayed in the calculation result Set default to set the default drive Set deleted on/off to hide/display records with deleted tags Set delimiter to set the delimiter for fields and variables displayed on the full screen Set delimiter On/Off Select optional delimiter Set device to screen/print: Send the result of the @... Say command to the screen/printer Set dohistory On/Off To set commands in the command file to historical records Set echo on/off command line return to screen or printer Set escape on/off allows escape to exit/continue command File Execution Set exact on/off in string comparison, requires/does not require accurate consistency Set exaclusive On/Off To set database file sharing Set fields on/off: set some/all fields in the currently opened database to available Set fields to specify accessible fields in the opened database Set filter to exclude all records in the database that do not meet the given conditions in the operation Set fixed on/off fixed/unfixed display decimal places Set format to open a specified format file Set function set F1-F9 function key When set heading on/off is set to list or display, the field name is displayed/Not Displayed Set help on/off: determines whether to prompt the user when an error occurs. Set history on/off determines whether or not to store the command for re-calling Set history to determines the number of display History commands SET index to open the specified index file Set intensity on/off implement/disable reverse display for full screen operations Set margin to set the left tab of the printer Set memowidth to define the output width of the remarks field and the implicit width of the report command Set Menu on/off determine whether to display the menu in full screen operations Set message to define the strings displayed at the bottom of the screen in the menu Set odometer to change the response interval of the talk command Set order to specify the index file in the index file list Set path to specify the path for file search Set print on/off transfer/do not transmit output data to the printer Set printer to send printed data to another device or file Set procedure to open the specified process File Set relation to join two numbers based on a keyword expression