Guiqiu to organize the VF instruction

VF common commands and functions

command

store {} | {} | {/} to db

VF commonly used commands and program command I. Main commands:
1, create
: Create a new table.
Format: Create
[u003CFile> |?] (Note, the command character can be taken in the previous four characters, which can be omitted later, that is, the same; This is; | The pipeline symbol indicates that the two parameters can only be selected, not to choose at the same time, the same.)
Note: The file refers to the establishment of the VFP database file with the expansion of the expansion. The system will pop up the dialog box, requiring users to enter the table name they want to establish. The dialog box will also pop up without a file name or question mark system in the command, requiring users to enter the table name they want to establish.
2, modify
structure
: Display the table file structure and allow the structure of this table.
Format: MODIFY
structure
Instructions: Only after opening the table file with the USE command can the structure of the table file be displayed or modified.
3, APPEND
: At the end of the current table (no matter whether there is a record in the table), the additional record (in the current table refers to the currently used table).
Format: Append
[blank]
Instructions: Add a blank parameter to the rear of the current table to add a blank record at the rear of the current table. When there is no Blank parameter, it means adding a record to the rear of the current table and requiring the user to enter the corresponding field content.
4, insert
: Insert a new record in the middle of the table file.
Format: Insert
[before]
[blank]
Instructions: Insert
n Insert a record before the current record;
insrt
Beface
blank
In the empty record before the current record.
5, browse
: It is mainly used to open the browse window, check the table file and modify it at the same time.
Format: browse
6, use
: Open and close the table file.
Format: use
[u003Cfile name>]
use
Instructions: The previous command is used to open the specified table file of the u003Cfile name>. At the same time, open the corresponding remarks file (.fpt file); the latter command close the currently opened table file.
7, list, and display
: The content, structure or state of the display table (.dbf).
Format: list | display
[off]
[u003Crange>]
[fields]
u003Cexpression table>
[While
u003CTesting>]
[for
u003CTeminaries>]
[to
print | to
file
u003Cfile>]
list | display
structure
to
print | to
file
u003Cfile>]
list | Display r
[to
print | to
FILE
u003CFile>]
Instructions: The command with the OFF parameter does not display the record number, the scope specifies which records are specified, the scope includes:
RCORD
n
Sexes. Number records, next
n
The records of the current record, REST
All records from the beginning of the current record to the end of the file, all
all the records. The non -selected range is ALL; after Fields, the field name, the field name and field name are divided into
. After the condition, the conditions are followed by the conditions. The difference is that if the conditions after the whole are met, the condition will stop looking; the conditions after the for find all the records that meet the conditions. To
print and to
file
u003CFile> indicates that the results are printed out and output the display results on the printer. After displaying the screen full screen, the Display command is required to continue displaying by any key, and in
In this command, if the range is omitted, the current record is only displayed. In the format, the following two commands are display table structures and working status (Status).
8, the positioning of the record
: Positioning the record with a record pointer (Pointer).
Format: go [to]
Record
n | Top | bottom

skip
[ |-] n Instructions: The first command again Called absolute positioning. Among them, record
n is positioned to N No. N records, TOP is positioned to the first record, and
bottom is positioned to the last record. The second command is positioned to the nn record, n is a value. The third command is also called relatively fixed
bit. It uses the current record as the benchmark (-) or back ( ) n records. If the option is not selected, a record is transferred by the default record pointer.
9, Change, and Edit
: Show fields to be edited or modified.
Format: Change | Edit
[u003Crange>]
[fields
u003Cfield famous table>]
[while
u003Cth condition>
[for
u003CTeminaries>]
10, browse
: Open a "browse" window for users to browse or modify records.
Format: browse
[fields
u003Cfield name table>]
11, replace
: Use the value of the expression value in the command of the field content in the command command. Essence
format: replace
[u003Crange>]
u003Cfield 1>
with
u003Cexpression 1> [, u003Cfield 2>
with
u003Cu003Ci Express 2>]
[for
u003CTerit and>
[condition>]
12, delete, pack, zap and recall
: respectively It is to delete the delete mark, delete, delete all records, and cancel the selected table record deletion logo.
Format: delete
[u003Crange>]
[condition>]
[for
u003Ccondition>
(special case: delete
file
filename.dbf,
This delete the specified table file)
pack
zap
Rcall
[u003Crange>]
[for
u003CTeminaries>]
[While u003Cthlasses>
13, sort, and index
. Based on the values ​​of the keyword expression, it is arranged from small to large, and is stored in a file or a logo of the file name or composite index file specified by the index file specified after TO.
format: sort
to
u003Cfile name>
ON
u003Cfield name 1>
[/a]
[/c]
[/d] [, u003Cfield name 2>
[/a]
[/c]
[/d]] ...
[ascending |]
[u003Crange>]
[for
u003Ccondition>]
[condition>]
[fields u003Cfield table>]
index
ON
u003Ckeyword expression>
to
u003Cfile name>
index
ON
u003Ckeyword expression>
tag
u003Cu003Cu003Cu003Cu003Cu003Cu003Cu003Cu003Cu003Cu003Cu003C Identification name>
[of
u003Cfile name>]
[for
u003Ccondition>]
Instructions: In the first command,/A is promoted by the field name. Sorting,/d sort in sequences in the field name,/c ignore the lower case, and for character type
keywords, ascending and separate sequences and order, respectively. The first command is established .DBF form file, the second command
to establish a .idx single index file, and the third command to establish the .cdx composite index file (Compound
index).
14, use
u003Ctable file name>
index
u003C>, SET
index nto and set norder nto r
: Open the index file, open the index file, and change the main index while opening the form file.
format: USE
u003Ctable file name>
index
u003C
set
index nto
>]
Set
order
to
[u003CIndex file name>] (Special: Reconvilding: Rendex)
15, Find, Seek and Locate and Continue
Function: The first two commands Find and Seek are the first records of the same record in a table where the index file has established an index file. The latter command directly query the content of the field in the table after opening the table file with the USE.
Format: Find
u003C"string"> | u003C"string> seek
u003Cexpression>
lock
[u003Crange>]
[foror
u003CTeminaries>]
[While u003Cthlasses>]
Continue
The difference: The difference between the Find command and the seek command is the former and the string, while the latter follows the expression. After using the Locate command to find
, a matching record, you can use the remaining part of the Continue command to search for other matching records.
16, count
: Statistics the number of recorded records in the current table file.
Format: Count
[u003Crange>]
[for
u003Ccondition>
[condition>
[to
u003CMemory variable name>]
Instructions: Memory variable names can be available in any character except parameters.
17, SUM
: All the numerical fields recorded or specified in the current table selected in the current table or the numerical expression consisting of a specified field is accumulated.
format: SUM
[u003Crange>]
[value u003Cexpression]
[to
u003Cmemory variable name table>]
[for n [for
u003CTeminaries>]
[While u003CTemperature>]