Partager via


Table Manipulation Language

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.

See Also

Reference

Table Designer (Visual FoxPro)

Other Resources

Databases

Query and View Designers

Language Categories