4 thoughts on “Guiqiu to organize the VF instruction”

  1. u003Cp> Append adds one or more new records at the end of the table u003C/p>
    u003Cp> APPEND from to read the record from one file, add to the rear of the current table u003C/p>
    u003Cp> AVERAGE Calculate the average of the value expression or field u003C/p>
    u003Cp> u003Cfont color =#f70909> browse to open the browse window to display the current or selected record records u003C/font> u003C/font> u003C/font> u003C/font> u003C/font> u003C/font> /
    u003Cp> Change Show the field to be edited u003C/p>
    u003Cp> Close to close various types of files u003C/p>
    u003Cp> Copy Structure Create a new empty free table u003C/p>
    u003Cp> Copy to Array to copy the current data in the selected table to the array u003C/p>
    u003Cp> Copy to Select the content of the selected form to create a new file u003C/p>
    u003Cp> Count statistics table records u003C/p>
    u003Cp> Create to generate a new table u003C/p>
    u003Cp> Create database Create and open a database u003C/p>
    u003Cp> Delete to mark the records to be deleted u003C/p>
    u003Cp> delete database to delete the database from the disk u003C/p >
    u003Cp> Delete View deletes a SQL view from the current database u003C/p>
    u003Cp> Display to display information related to the current table in the main window or user custom window u003C/p>
    u003Cp> Display database displays information about the current database, or the fields, naming companies in the current database u003C/p>
    u003Cp> interlock, table or view information u003C/p> r r r
    u003Cp> Display Memory Display the current content of memory variables and array u003C/p>
    u003Cp> Display Structure Display the structure of a table file u003C/p>
    u003Cp> Display Views Display in the current database. Regarding SQL view information and whether the SQL view is based on local u003C/p>
    u003Cp> or remote table information u003C/p>
    u003Cp> Drop Table to put a one The table is removed from the database, and it deletes it from the disk u003C/p>
    u003Cp> Drop View deletes the specified SQL view from the current database u003C/p>
    u003Cp> find search record u003C/ P>
    u003Cp> Go | GOTO moves the record pointer to the specified record u003C/p>
    u003Cp> insert records u003C/p>
    u003Cp> Join to two databases will be two databases File mergers u003C/p>
    u003Cp> u003Cfont color =#ff3300> List continuous display table or environmental information u003C/font> u003C/p>
    u003Cp> list database continuously display the relevant current database Information u003C/p>
    u003Cp> Locate searches in order to find the first record that meets the specified logic expression u003C/p>
    u003Cp> Modify database to open the database designer so that you can allow you Modify the current database u003C/p>
    u003Cp> Modify Structure display designer u003C/p>
    u003Cp> Modify View display view designer u003C/p>
    u003Cp> Open DataBase Open a database u003C/p>
    u003Cp> Pack Permanently Delete the Dispeling Mark from the current table u003C/p>
    Record u003C/p>
    u003Cp> Scan … Endscan running scanning data table file u003C/p>
    u003Cp> scatter to copy data from the current record to a set of memory variables or arrays u003C/P>
    u003Cp> Seek finding record command u003C/p>
    u003Cp> Select activation designated work zone u003C/p>
    u003Cp> set deleted The recorded records, and other commands are u003C/p>
    u003Cp> Can it operate them u003C/p>
    u003Cp> set index and open one or more index files for the current table; u003C /
    u003Cp> Set Relation Establish a relationship between two open tables u003C/p>
    u003Cp> SKIP to move the record pointer forward or move backward u003C/p u003C/p u003C/p u003C/p u003C/p >
    u003C P> Sum Seeks peace on the specified value field or all numerical fields of the current selected table. P> UPDATE update the record of the database file u003C/p>
    u003Cp> Use to open a table and its related index files, or open a SQL view u003C/p>
    u003Cp> zap delete from the table from the table All the tables are left with the structure of the table u003C/p>
    u003Cp> u003Cfont face = black body color =#0968f7> u003Cstrong> 2. Index and sorting command u003C/strong> u003C/font> u003C/ P>
    u003Cp> Copy Indexes Create a composite index logo from a single index .idx file u003C/p>
    u003Cp> Delete tag to delete the logo from the composite index (.cdx) file u003C/p>
    u003Cp> Index Create an index file, using this file to display and access the table records in some logical order u003C/p>
    P>
    u003Cp> sort to hold the current selection table. 1111ee> u003Cstrong> Three, Visual FoxPro Environment Setting Command u003C/strong> u003C/font> u003C/p>
    u003Cp> Display Status Display the environment of the environment u003C/p>
    u003Cp> u003C Font face = black body color =#1111ee> u003Cstrong> 4. Set setting command u003C/strong> u003C/font> u003C/p>
    u003Cp> set console to activate or abolish the main window or activity from the program to the main window or activity User custom window u003C/p>
    u003Cp> Output of the port u003C/p>
    u003Cp> set default specifies the default drive, directory or folder u003C/p>
    u003Cu003Cu003Cu003Cu003Cu003Cu003Cu003C/ P> Set Device Orient the output result [email protected]… SAY to the screen, printer or file u003C/p>
    u003Cp> Set exact. Specify the rules used when comparing the two string of different lengths u003C/p>
    u003Cp> Set Path specify the path of the search file u003C/p>
    u003Cp> SET SAFETY setting confirmation mode u003C/p>
    u003Cp> Set talk decide whether to display the command result u003C/p>
    u003Cp> u003Cfont face = black body =# 0909F7> u003Cstrong> Five, Visual FoxPro file management command u003C/strong> u003C/font> u003C/p>
    u003Cp> Copy file Copy any type of file u003C/p>
    u003Cp> Deletete File delete files from the disk u003C/p>
    u003Cp> rename to change the file name to a new name u003C/p>
    u003Cp> Type display file content u003C/p>
    u003Cp> u003Cfont face = black body color =#1A42e6> u003Cstrong> 6. Visual foxpro input output commands u003C/strong> u003C/font>
    u003Cp>? |? Value, and output calculation results u003C/p>
    u003Cp> | Text direct output commands u003C/p>
    u003Cp> clear release specified items from memory u003C/p>
    u003Cu003Cu003Cu003Cu003Cu003Cu003C/p>
    u003Cu003Cu003Cu003Cu003Cu003C/ P> Create Form Open the Form Designer u003C/p>
    u003Cp> DIR or Directory Display the information of the file or the file in the folder. The compiled form or form set u003C/p>
    u003Cp> input data by the user u003C/p>
    u003Cp> Modify form to open the form designer, you can modify or create a form from it. u003C/P>
    u003Cp> Modify Query Open the query designer, you can modify or create a query u003C/p>
    u003Cp> Modify Screen to open the form designer u003Cp> Read read the established object u003C/p>
    u003Cp> u003Cfont face = black body color =#1111ee> u003Cstrong> Seven, Visual FoxPro menu command u003C/strong> u003C/font> u003C/ P>
    u003Cp> Define menu Create a menu bar u003C/p>
    u003Cp> define pad Create a menu title on the household menu bar or the system menu bar u003C/p>
    u003Cp> Menu Create menu u003C/p>
    u003Cp> Menu to start menu u003C/p>
    u003Cp> Modify Menu Open the menu designer, which can be modified or created for the menu system u003C/p>
    u003Cp> u003Cfont face = black body COLOR =#0909F7> u003Cstrong> 8. Visual foxpro print command u003C /Strong> u003C/font> u003C/p>
    u003Cp> Modify Report to open the report designer, you can modify or create a report u003C/p>
    u003Cp> Set Printer to open or turn off to the printer to the printer Output, or output the result to a file, port u003C/p>
    u003Cp> u003Cfont face = black body color =#0000ff> u003Cstrong> 9, Visual FoxPro program management command u003C/strong> u003C/font > u003C/P>
    u003Cp>

  2. 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>]

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top