FOXBASE command set

Source: Internet
Author: User
Tags field table

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
 

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.