Current location - Health Preservation Learning Network - Healthy weight loss - Summarize all commands and file extensions in VFP database?
Summarize all commands and file extensions in VFP database?
Display the expression string on the next line? Display the expression string in the current line @ ... Display the data on the screen or print the data on the printer according to the format set by the user. Accept assigning the string to the memory variable Append adding the record to the database file Append adding the record to the database file from other library files. Calculate the arithmetic average of the numerical expression. Browse the full screen to display and edit the data. Call the binary file CANCEL in the library record running memory to terminate the program execution and return to the point prompt. In multiple-choice statements, specify a conditional change to edit the specified fields and records in the database. Clear the screen, move the cursor to the upper left corner of the screen, clear all, close all open files and release all memory variables. Select workspace CLEAR FIELDS 1 clear field name table CLEAR GETS to build it with the SET FIELDS TO command, and release any variables of the current GET statement from full-screen reading. Clear Memory Clears all current memory variables, programs, program buffers, and pre-inputs. Except for keyboard buffering to close files of the specified type. CONTINUE points the record pointer to the next record that meets the conditions given by the LOCATE command, which appears after the LOCATE command. If there is no positioning, an error will occur. Copy to Copy a database file used by another library file or text file. Copy files Copy any type of file. The copied structure is extended as a record to the structure of the current library file. Create a new library file copy structure Copy the structure of the library file in use to the target library file count Calculate the number of specified records within a given range Create a new database file structure and register it in the directory Create a new library file file file file file creation label Create and edit a label. Format file creation report establishes the object of eDIting report format file deletion tag specified record deletion file deletion unopened file dimension definition memory variable array DIR or directory list file directory on specified disk display the record and field di of open library file. Display file refers to the file display history on disk refers to the executed command display memory paging display current memory variable display state display system state and system parameter display structure display current stack file structure DO execute FoxBase program DO CAS. Mark of multiple judgments in e program, mark of a loop in DO WHILE program, edit, edit the contents of database fields, pop up, make the printer change pages, and compare the PROW () function with PCOL (). If the function value is set to 0, otherwise, another conditional selection path is provided in the IF ... ENDIF structure ENDCASE terminates the end mark of the loop body in the ENDIF judgment body IF of the multi-judgment ENDDO program ... ENDIF structure end mark ERASE deletes the specified file exit from the directory, and executes the command to exit the loop in the loop body FIND to move the record pointer to the first one. FLUSH clears all disk access buffers gatherefrom on records that contain index keywords consistent with the given string. Assign the values of array elements to the current record in the database. GO/GOTO moves the record pointer to the specified record number help to activate the help menu. Explain that FoxBASE+ IF command specIFies the judgment condition in if ... ENDIF structure. INDEX generates an index file according to the specified keyword. INPUT accepts the expression entered by the keyboard and INSERTs a record at the specified location for the specified memory variable insert. JOIN merges the specified records and fields from two database files into another library file. The keyboard fills a string into the keyboard buffer. Labels are printed in the specified label format. Label file list lists records and fields in the database. File list File list File list Current disk directory File list History list Executed command list Memory list Current memory variables and their value list Status list Current system status and system parameters. The list structure lists the library structure of the currently used database. LOAD transfers the assembly language program from disk to memory location and moves the record pointer to the record that is true under given conditions. LOOP skips all statements between LOOP and ENDDO in the loop body. Return to the first line of the loop menu, activate the menu defined by a group of @ ... Prompt the command to enter the word processing state of FoxBASE+ system, and edit an ASCII text file (if the file name is specified as suffix. PRG, edit a FoxBASE+ command file) Modify the file Edit a universal ASCII text file Modify the label Create and edit a label (. LBL) File modification report Create and edit report format file (. FRM)。 File modification structure Modify the currently used library file structure Note/* Insert a line of comments in the command file (program) (this line will not be executed) about transferring the program according to the specified conditions, otherwise it will be executed in many cases. If other conditions are specified in the package, all records marked for deletion will be deleted. PARAMETERS specifies that the subprocess accepts the parameters passed by the main process, and the memory variables stored in the subprocess are private, and the attributes of the memory variables are defined as local attributes. A procedure marks the beginning of a subprocess, and PUBLIC defines a memory variable as a global property. Exit Close all files and exit FoxB. ASE+ READ activates GET statement by accepting data input in GET statement, calling, restoring records marked with deletion and deletion, re-indexing, re-establishing original index files in use, releasing and clarifying current memory variables and renaming assembly language subroutines, modifying file names, replacing original contents in database fields with specified data, and displaying datagrams in the form of reports. Table Recovery Recover Storage Variables from Storage Variables File Recovery Screen. Mem) and load the previously stored screen image RESUME to make the suspended program continue to retry from the suspended breakpoint and return to the calling program from the currently executed subroutine, and return to the end subroutine from the original calling line and return to the calling program RUN/! Execute an operating system program SAVE TO in FoxBASE+, and store the current memory variables and their values in the specified disk file (. mem)。 Save the screen and store the current screen display 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 matching the specified expression. SELECT a workspace, SET FoxBASE+ control parameter, Set Alternative On/ off, set transmission/ Do not transfer the output to the file set. Alternately create files for storing the output. Set the bell on/off. Set the bell on/off when inputting data. Set the continue/off. Set the last record to copy/not copy to the added record. Set the century on/off. Set the date variable to/not set the century prefix. Set the clear on/off. Set the screen information can/can't be cleared. Set color/monochrome display setting color to set screen display color setting confirmation on/off in full-screen editing mode. Need/don't need to automatically skip to the next field. Set the set console to on/off to transmit/not transmit the output to the screen. Set the date to format the date expression. Set debug on/off to transmit/not transmit ECHO's output to printer Set decimals to set decimal places to be displayed in calculation result set Set default value Set default driver Settings Delete On/Off Set Hide/Set Delimiter Set Delimiter On/Off to display fields and variables in full screen Select optional separator setting device to filter/print to transmit @ results ... Speak commands to screen/printer Set History On/Off Set Save/Don't save commands in command file to history. The SET ECHO ON/OFF command line is sent back to the screen or printer. Setting ESCAPE on/off allows ESCAPE to exit/continue executing the command file. Setting Accurate On/Off In the comparison of character strings, accurate and consistent settings are required/not required. EXACLUSIVE ON/OFF settings * * * Enjoy the on/off settings of setting fields in database files, and some/all fields of the currently opened database are available. Set the filter to specify accessible fields in the open database. In this operation, all records in the database that do not meet the given conditions will be excluded. Set fixed on/off fixed/set format to open the specified format file, set the function, set the function key value of F 1-F9, set the title on/off, display/not display the field name, and set the help on/off. When an error occurs, Whether to prompt the user to set the history on/off, decide yes/no, store the command so as to call the setting history to decide the number of displayed history commands, set the index to open the specified index file, set the intensity on/off to realize full-screen operation/set the margin to set the left margin of the printer, set the MEMOWIDTH to define the output width of the memo field and the implied width of the report command, Setting Menu On/Off Determines whether to display the string message displayed on the bottom line of the screen in the menu. Set the odometer to change the response interval setting order of the call command. Specify the index file setting path in the index file list. Specify the path setting for file retrieval. Print On/Off will transfer output data to the printer. Set the printer to transfer print data to another device or file setting process. Open the specified process file setting relationship. Connect two database files according to keyword expressions. Set the security on/off setting protection. When rewriting the file, prompt the user to confirm that the scoreboard on/off setting is set to Yes/No to display the status information of FoxBASE+ on line 0 of the screen. Set the status on/off control to Yes/No to display the status line and set the step on/off. After each execution of a command, pause/not pause the program's execution setting TALK ON/OFF Whether to transmit the result of the command execution to the screen setting TYPEAHEAD Setting the size of the keyboard buffer setting UNIQUE ON/OFF The first/all records with the same keyword in the index file SKIP is subject to the current record pointer. Move the pointer back and sort to generate sorted crying file storage assignment statements and based on one or more fields of the database file. Calculates and displays a range of expressions recorded in the database, and suspends the execution of the program. Text ... ENDTEXT displays the current cursor position on the screen ... The text data block is always ahead of time. The sorted files generate a summary file. TYPE displays the contents of the ASCII file. Unlock the locking operation of the current library file on records and files. UPDATE allows batch modification of the database. USE the use command with the file name to open this database file. If there is no file name, close the database file of the current operation and wait for the execution of the suspended program, and press any key to continue ZAP to delete all records of the current database file (unrecoverable). Action diagram document of the act wizard.

. An application or active document generated by an application.

. Cdx composite index

HTML help compiled by. chm

. Dbc database

. Dbf table

. Dbg debugger configuration

Comments on ... Dct database

. Dcx database index

. Dep related files (created by the installation wizard)

. Dll Windows dynamic link library

. Err compilation error

Supported libraries. esl Visual FoxPro

Exe executable program

. Fky macro

. DLL

. FMT format file

Comments on ... FPT table

. FRT report notes

. Frx report

. Fxp compiler

. H header file (required by Visual FoxPro or C/C++ program)

. hlp WinHelp

. HTML

. Idx index, compressed index

. Lbt label remarks

. Lbx label

. Log code range log

List of documents. Lst wizard

. Mem storage variable saving

. Mnt menu remarks

. Mnx menu

The menu program is generated by. journal

. Mpx compiler menu program

. Ocx ActiveX control

. Pjt project notes

. Pjx project

. Prg program

The query program is generated by. qpr

. Qpx compiler query program

. Sct form comments

. Scx form

Screen program generated by. Spr (only applicable to previous versions of FoxPro)

Spx compiler screen program (only applicable to previous versions of FoxPro)

. Tbk remarks backup

. Txt text

Comments on ... Visual class library

Vcx visual class library

. Vue FoxPro 2.x view

. Win window file

Table (. dbf)

Database (. dbc)

Form (. scx)

Label (. lbx)

Menu (. mnx)

Project (. pjx)

Report (. frx)

Visual class library (. vcx)