Table Manipulation Language

Article
06/18/2008

These commands and functions make it possible for you to create, manipulate, and monitor table files.

Use	To
ADD TABLE Command	Add a free table to the current database.
ALINES( ) Function	Copy each line in a memo field to a corresponding row in an array.
ALTER TABLE - SQL Command	Modify the structure of a table.
APPEND Command	Add records to the end of a table.
AUSED( ) Function	Place table aliases and work areas for a data session into a variable array.
AVERAGE Command	Compute the arithmetic mean of numeric expressions or fields.
BEGIN TRANSACTION Command	Begin a transaction.
BROWSE Command	Open the browse window and display records from a table.
CHANGE Command	Display fields for editing.
CLOSE Commands	Close open tables.
COPY MEMO Command	Copy the contents of a memo field to a text file.
COPY STRUCTURE Command	Create a new empty table with the same structure as the currently selected table.
COPY STRUCTURE EXTENDED Command	Create a new table with fields containing the structure of the currently selected table.
COPY TO Command	Create a new file from the contents of a table.
COUNT Command	Count table records.
CPCURRENT( ) Function	Return the current code page settings.
CPDBF( ) Function	Return the code page information that a table was marked with.
CREATE Command	Build a new table.
CREATE FROM Command	Create a table from a table created with the COPY STRUCTURE EXTENDED command.
CREATE QUERY Command	Open the Query designer.
CREATE TABLE - SQL Command	Build a new table.
CURVAL( ) Function	Return field values.
DELETE Command	Mark records for deletion.
DELETE - SQL Command	Mark records for deletion.
DELETED( ) Function	Determine if a record is marked for deletion.
DISPLAY STRUCTURE Command	Display the structure of a table.
DISPLAY TABLES Command	Display the names and information about all the tables in a database.
EDIT Command	Display fields for editing.
END TRANSACTION Command	End a transaction.
EXPORT Command	Copy data from a table to a file in a different format.
FLUSH Command	Save table and index changes to disk.
GETFLDSTATE( ) Function	Return a numeric value indicating the status of a field in a table or cursor.
GETNEXTMODIFIED( ) Function	Get the record number for the next modified record in a buffered table or cursor.
IMPORT Command	Import data from an external file format to create a new table.
ISEXCLUSIVE( ) Function	Determine if a table is opened exclusively.
ISREADONLY( ) Function	Determine if a table is opened as read-only.
LIST TABLES Command	Display the names and information about all the tables in a database
MEMLINES( ) Function	Return the number of lines in a memo field.
MLINE( ) Function	Return a specific line in a memo as a character string
MODIFY GENERAL Command	Open editing windows for general fields in the current record.
MODIFY MEMO Command	Open an editing window for a memo or blob field in the current window.
MODIFY QUERY Command	Open the Query Designer.
MODIFY STRUCTURE Command	Display the Table Designer.
OLDVAL( ) Function	Return the original values for fields that have been modified but not updated.
PACK Command	Permanently remove all records in a table that have been marked for deletion and reduce the size of a memo file associated with the table.
RECALL Command	Unmark records marked for deletion in a table.
REFRESH( ) Function	Refresh data in an updatable SQL remote or local view, or CursorAdapter cursor.
REMOVE TABLE Command	Remove a table from the current database.
REPLACE Command (Visual FoxPro)	Update table records.
REPLACE FROM ARRAY Command	Update data in fields with values from a variable array.
RENAME TABLE Command	Rename a table.
ROLLBACK Command	Cancel any changes made during the current transaction.
SELECT Command	Activate the specified work area.
SELECT - SQL Command	Retrieve data from one or more tables.
SET ANSI Command	Determine whether to pad a shorter string with spaces when making a SQL string comparison or binary expression with zero (0) bytes when making a binary expression comparison in SQL commands using the equal sign operator (=).
SET AUTOSAVE Command	Determine whether Visual FoxPro flushes data buffers to disk when you exit a READ or return to the Command window.
SET DATASESSION Command	Activate a specified forms data session.
SET DELETED Command	Specify whether Visual FoxPro processes records marked for deletion and whether they are available for use with other commands.
SET FIELDS Command	Specify which fields in a table can be accessed.
SET NULL Command	Specify how null values are supported by various commands.
SET OLEOBJECT Command	Specify if Visual FoxPro searches the registry when an object cannot be located.
SET OPTIMIZE Command	Enable or disable Rushmore Query Optimization.
SORT Command	Sort records in a table and output the sorted records to a new table.
SUM Command	Total numeric fields in a table.
SYS(2029) - Table Type	Return a value corresponding to the table type.
TABLEREVERT( ) Function	Discard changed made to a buffered row or a buffered table or cursor and restore the OLDVAL( ) data.
TABLEUPDATE( ) Function	Commit changes made to a buffered row, a buffered table, or a cursor adapter.
TOTAL Command	Compute totals for numeric fields in a table.
TXNLEVEL( ) Function	Return a numeric value indicating the current transaction level.
UPDATE - SQL Command	Update records in a table with new values.
USE Command	Open a table.
USED( ) Function	Determine if an alias is in use or a table is open in a specific work area.
ZAP Command	Remove all records from a table, leaving just the table structure.

Share via

Table Manipulation Language

See Also

Reference

Other Resources

Additional resources