FoxPro Common Commands

Visual FoxPro Formerly known as Foxbase, was originally launched by the American Fox software company in 1988 with a database product that runs on DOS and is compatible with the Xbase series. FoxPro is an enhanced version of Foxbase, with the highest version having been 2.6. Then, in 1992, Fox software was acquired by Microsoft and developed to enable it to run on Windows and renamed Visual FoxPro. FoxPro has a great improvement in function and performance, mainly introducing the controls such as window, button, list box and text box, which can further improve the development ability of the foxbase system.

Visual FoxPro abbreviation VFP, with VB, Delphi is the same program development tools, VFP because of the free DBF format database, in the domestic once is very popular development language, now many units of MIS system are developed with VFP. VFP is mainly used in small-scale enterprise MIS system development, of course, like industrial control software, multimedia software development. Because VFP does not support multi-threaded programming, its DBF database in a large number of clients in the network environment of data processing capacity is difficult, coupled with Microsoft launched SQL database, and VB, VC and other programming tools, so the input of VFP gradually reduced, Microsoft has made clear that the present, VFP9 will be the last version of VFP.

ACCEPT to assign a string to a memory variable
APPEND Append records to database files
APPEND from other library files to add records to the database file
AVERAGE calculating the arithmetic mean of a numeric expression
BROWSE Full screen display and edit database records
Call runs a binary file in memory
CANCEL terminates program execution, returns a dot prompt
Case in a multi-select statement, specify a condition
Change to edit the specified fields and records in the database
Clear clean screen and move the cursor to the upper left corner of the screen
CLEAR all close all open files, free all memory variables, select the 1th workspace
Clear fields clears the table of field names established with the set domain to command
CLEAR GETS the variable that frees any current get statements from full-screen read
Clear memory clears all currently-variable
Clear Program Erase Buffer
Clear TYPEAHEAD Clear the keyboard buffer
Close closes the specified type file
CONTINUE The record pointer to the next record that satisfies the given condition of the locate command, which appears after the locate command. Error if no locate
Copy to the database file to be used for copying another library file or text file
Copy file copies files of any type
COPY STRUCTURE extened to the current library file structure as a record, create a new library file
Copy STRUCTURE to copies the structure of the library file in use to the destination library file
Count calculates the number of records specified in a given range
CREATE defines a new database file structure and enlists it in the directory
Create from creates a new library file based on the library structure file
Create label to create and edit a label format file
Create report Create a format file
Delete Adds a deletion tag to the specified record
Delete file deletes one of the files that are not open
DIMENSION defining an array of memory variables
DIR or directory lists the file directories on the specified disk
Display displays the records and fields of an open library file
DISPLAY files Check the file on disk
DISPLAY history check for executed commands
Display memory paging shows current RAM variables
Display status displays system status and system parameters
Display STRUCTURE shows the structure of the current library file
Do Execute Foxbase Program
A sign of the start of multiple judgments in a Do case program
A flag that starts a loop in a Do while program
Edit the contents of a database field
EJECT the prow () function and the Pcol () function value to 0 by making the printer page-changing commands
ELSE in If ... Another conditional selection route is provided in the ENDIF structure
Endcase Terminating multiple judgments
A sign of the end of a loop body in a Enddo program
ENDIF judgment Body If ... ENDIF structure End Mark
ERASE Delete the specified file from the directory
Exit executes the exit Loop command in the loop body
FIND moves the record pointer to the first record containing the index keyword consistent with the given string
FLUSH clears all the disk access buffers
GATHER from assigns the value of an array element to the current record in the database
Go/goto move the record pointer to the specified record number
Help activates the aid menu, explaining foxbase+ commands
If in the If ... Specifying conditions in a ENDIF structure
Index generates an indexed file based on the specified keyword
INPUT accepts an expression typed by the keyboard and assigns the specified memory variable
Insert inserts a record at the specified location
JOIN combines the specified records and fields into a different library file from two database files
KEYBOARD filling a string into the keyboard buffer
Label from printing labels with the specified label format file
List lists records and fields for database files
List files lists the file in the current directory of the disk
List history lists the commands that have been executed
List memory lists the current RAM variables and their values
List status lists current system state and system parameters
List STRUCTURE lists the library structure of the database currently in use
Load will raise the assembly language program from disk into memory
LOCATE move the record pointer over a record that is true for a given condition
Loop skips all statements between loops within the loop and Enddo, returning to the first line of the loop body
MENU to activates a set of @ ... Prompt menu for command definition
MODIFY command enters the word processing state of the 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 generic ASCII code text document
MODIFY label to create and edit a label (. LBL) file
MODIFY report Create and edit a format file (. FRM) file
MODIFY STRUCTURE Modifying the library file structure currently in use
note/* Insert a line comment in the command file (program) (The bank is not executed)
On transfer program execution according to specified conditions
OTHERWISE Specify in multiple judgments (do cases) other than the given condition
PACK completely removes the record with delete tag
PARAMETERS Specifies the memory variables that are stored by the parameters that the sub-procedure accepts as passed by the main procedure
PRIVATE defines the properties of memory variables as local properties
PROCEDURE the beginning of a child process flag
Public defines the global nature of memory variables
Quit close all files and exit foxbase+
READ activates the Get statement and exactly accepts the data entered in the Get statement
RECALL Restore record with delete plus remove tag
REINDEX re-establishing the original index file being used
RELEASE clear current memory variables and assembly language subroutines
RENAME Modifying file names
Replace replaces the contents of the database field with the specified data
Report FORM displays data reports
The RESTORE from memory variable file (. MEM) to recover memory variables in
Restore screen loads the previously stored onscreen image
Resume causes a paused program to resume execution from a paused breakpoint
RETRY returns the calling program from the currently executing subroutine and re-executes from the original calling line
Return ends the subroutine, returns the calling program
run/! Executing an operating system program in foxbase+
SAVE to the current memory variable and its value into the specified disk file (. MEM)
Save Screen stores the current display contents in a specified memory variable
Scatter moving data from the current database file into the specified array
SEEK moves the record pointer to the first record containing the index keyword that matches the specified expression
Select a workspace
Set setting foxbase+ control parameters
Set ALTERNATE on/off settings transmit/not transmit output to a file
Set ALTERNATE to create a file to store the output
Set bell on/off setting input data ringing/not ringing
Set CARRY on/off setting last record copied/not copied to added record
Set CENTURY on/off date type variable to/Don't century prefix
Set clear on/Off Settings screen information can/cannot be cleared
Set color on/off setting colour/monochrome display
Set Color to Settings screen display color
Set CONFIRM on/off settings in full screen editing mode, requires/does not require automatic skip to the next field
Set CONSOLE on/off setting outputs are transmitted/not transmitted to the screen
Set date format for dates expression
Set DEBUG on/off settings transmit/not transmit echo output to the printer
Set decimals to sets the number of decimal digits to display for the calculation result
Set default to defaults to the drive
Set DELETED on/off setting hides/Displays records with delete marks
Set DELIMITER to sets delimiters for full-screen display fields and variables
SET DELIMITER on/off select optional delimiter
Set DEVICE to Screen/print will be @ ... The results of the say command are transmitted to the screen/printer
Set dohistory on/Off settings save/Do not save command in command file to history
SET echo on/off command line loopback to screen or printer
SET escape on/off allows ESCAPE to exit/Continue command File execution
SET exact on/off in a string comparison, requires/does not require exact consistency
Set exaclusive on/off setting database file sharing
Set fields on/off sets the currently open database for some/all of the available
SET field to specifies the fields that can be accessed in the Open database
Set FILTER to exclude all records in the database that do not meet the given criteria in the operation
SET fixed on/off fixed/non-fixed display scale
SET format to open the specified format file
Set function setting f1-f9 functional key value
Set HEADING/Don't display field names when setting list or display on/off
Set Help on/off determines if the user is prompted when an error occurs
SET history on/off determines whether the command is stored for recall
SET history to determine the number of historical commands to display
SET Index to open the specified index file
SET INTENSITY on/off for full screen operation/no reversal display
Set margin to Settings printer left page edge
SET Memowidth to define Memo field output width and report command implied width
Set menu on/off determines whether menus are displayed in full-screen operation
SET MESSAGE to define the string that appears in the bottom row of the menu
SET odometer to change the response time between talk commands
SET ORDER To specify an index file in the index file list
SET path to retrieve the specified paths for a file
SET PRINT on/off/non-transmitting output data to printer
SET PRINTER to transfer the printed data to another device or to a file
SET PROCEDURE to open the specified procedure file
SET RELATION to connect two database files according to one keyword expression
Set SAFETY on/off protection, prompting the user to confirm when overwriting a file
Set Scoreborad on/off setting Yes/no foxbase+ status information is displayed on line No. 0 of the screen
SET status on/off control Yes/no show status line
SET STEP on/off the execution of the program is paused/not paused whenever a command is completed
Set talk on/off whether to transfer the results of command execution to the screen
Set TYPEAHEAD to sets the size of the keyboard buffer
SET UNIQUE on/off the first/all records of the same keyword appear in the index file
SKIP moves the pointer back and forth, whichever is the current record pointer
Sort to produce a sorted library file based on one field or multiple fields of the database file
STORE Assignment Statement
SUM calculates and displays an expression of the database record in a range and
SUSPEND suspending (suspending) the execution of a program
TEXT ... Endtext Displays the current cursor position on the screen ... The text data block
Total to produce a summary file with totals for a pre-ordered file
TYPE Displays the contents of the ASCII code file
UNLOCK unlock records and files from the current library file
UPDATE allows batch modification of a database
Use the use command with the file name to open the database file. Close the current operation's database file when no file name is present
WAIT to pause the program execution and press any key to continue execution
ZAP deletes all records for the current database file (unrecoverable)

FoxPro Common Commands