FoxPro database file and record command

addtable Add a free table to the current database
APPEND add one or more new records at the end of the table
APPEND from array add record to table
APPEND from a file, appended to the end of the current table
APPEND General import OLE objects from a file and put them in a common field
APPEND Memo Copy the contents of a text file into a memo field
APPEND procedures appends stored procedures in a text file to the current database
AVERAGE computes the arithmetic mean of a numeric expression or field
BLANK clears data from all fields in the current record
Browse opens the Browsing window to display the records for the current or selected table
CALCULATE Financial and statistical operations on a field in a table or an expression that contains a field
Change displays the field you want to edit
Close various types of files
Close memo closes one or more notes in the edit window
COMPILE database Compilation stored Procedures
CONTINUE continue with Previous locate command
Copy memo copies the contents of the specified Memo field in the current record to a text file
Copy procedures The stored procedure in the current database to a text file
COPY STRUCTURE creates a new empty free table with the currently selected table structure
COPY STRUCTURE EXTENDED creates a new table whose fields contain the structure information of the currently selected table
Copy to array copies data from the currently selected table
COPY to create a new file with the contents of the currently selected table
Number of records in COUNT statistics
Create to generate a new Visualfoxpro table
Create CONNECTION creates a named connection and stores it in the current database
Create database creates and opens a data base
Create TRIGGER Delete, insert, or UPDATE trigger for table creation
Create view creates views files from the VISUALFOXPRO environment
Delete to mark the record to be deleted
Delete CONNECTION Deletes a named connection from the current database
Delete database deletes databases from disk
Delete TRIGGER removes the delete, insert, or update triggers from the table in the current database │
Delete view deletes a SQL view from the current database
Display displays information about the current table in the Visualfoxpro main window or in the user's custom window
Display CONNECTIONS displays information about named connections in the current database
Display database displays information about the current databases, or the fields in the current database, named connections, tables, or views
Display memory shows the current contents of the variable and array
Display procedures displays the name of the stored procedure in the current database
Display STRUCTURE shows the structure of a table file
Display TABLES displays information about all tables and tables contained in the current database
Display views displays information about the SQL view in the current database and whether the SQL view is based on local or remote table information
Drop table moves a table out of the database and removes it from the disk
Drop view deletes the specified SQL view from the current database
Edit to display the fields you want to edit
EXPORT copies the data from the Visualfoxpro table to a file in a different format
Find Lookup Records
FLUSH converts changes made to tables and indexes to disk
Free table Deletes a database reference from a table
GATHER replaces the currently recorded data in the currently selected table with data from an array, a memory variable group, or an object
go| GOTO moves the record pointer over the specified record
Import imports data from an external file, creating a new Visualfoxpro table
Insert Inserts a record
Join merges two database files
List continuous display of table or environment information
LIST CONNECTIONS continuously displays information about named connections in the current database
LIST Database continuously displays information about the current databases
LIST procedures continuously displays the name of the current database stored procedure
List TABLES continuously displays information for all tables and tables contained in the current database
List views continuously displays information about SQL views in the current database
LOCATE Search tables sequentially to find the first record that satisfies a specified logical expression
MODIFY CONNECTION Displays the connection designer, allowing you to interactively modify existing named connections in the current database
MODIFY database opens the Databases designer, allowing you to interactively modify the current database
MODIFY General open a common field in the current record in the edit window
MODIFY Memo Open the edit window for the current record Memo field
MODIFY PROCEDURE Open the Visualfoxpro text editor where you can create a new stored procedure for the current database
MODIFY STRUCTURE Display Table Designer
MODIFY View Display Designer
Open Database
PACK permanently deletes a record marked with a delete tag from the current table
PACK database Deletes a record marked with a delete tag from the current database
RECALL restore records with deletion marks in the selected table ·
Remove table removes a table from the current database
RENAME CONNECTION Renaming a named connection in the current database
RENAME table renaming tables in the current database
RENAME View renaming 3QL views in the current database
REPLACE updates the record contents of the table
REPLACE from array updates field contents using values from a memory variable array
SCAN ... ENDscan running the Scan data table file
Scatter copying data from the current record into a set of memory variables or arrays
Seek to find a record command
SELECT activates the specified workspace
SET Autoincerror whether to update or insert a value into the record when an auto-increment value produces an error
SET COLLATE Specifies the sort order of the character field in subsequent index and mixed operations
SET database Specifies the current databases
SET datasession activates the specified form data work period
SET DELETED Specifies whether Visualfoxpro handles records marked with a delete tag, and whether other commands can manipulate them
SET EXCLUSIVE Specifies whether Visualfoxpro open the table file on the network exclusively or in a shared manner
SET field specifies which fields in the table can be accessed
SET FILTER Specifies the conditions that must be met when accessing records in the current table
SET index opens one or more index files for use by the current table;
SET key specifies the range of access records based on the index keyword
SET lock activates or abolishes automatic file locking in certain commands
SET Multilocks Determines whether multiple records can be locked using look () or Rlock ()
When the set near find or Seek lookup record is unsuccessful, determine where the record pointer rests
SET Nocptrans prevent the conversion of selected fields in an open table to another code page
Set NULL determines how the Atltertable, CreateTable, and Insert-sql commands handle NULL values
SET Nulldisplay the corresponding character in the specified null value display
Set RELATION establishes a relationship between two open tables
Set Relationoff the established relationship between the parent table and the related child table in the currently selected workspace
SET reprocess Specifies the number or time that Visualfoxpro attempts to lock a file or record again after a lock attempt is unsuccessful
SET SKIP creates a one-to-many relationship between tables and tables
SET tablevalidate Specifies the execution level of a table
Set window of Memo setting a Memo field using the Windows
SKIP moves the record pointer forward or backward in the table
Sum sums the specified numeric field or all numeric fields of the currently selected table
Total calculates the sum of the numeric fields in the currently selected table
Update updates the records for the database file
Use to open a table and its associated index file, or open a SQL view
VALIDATE database guarantees the correctness of table and index locations in the current databases
ZAP removes all tables from the table, leaving only the structure of the table

FoxPro database file and record command