Table Manipulation

These commands and functions enable you to create, manipulate, and monitor table files.

ADD TABLE Command

ALINES( ) Function

ALTER TABLE - SQL Command

APPEND Command

AUSED( ) Function

AVERAGE Command

BEGIN TRANSACTION Command

BROWSE Command

CHANGE Command

CLOSE TABLES Command

COPY MEMO Command

COPY STRUCTURE Command

COPY STRUCTURE EXTENDED Command

COPY TO Command

COUNT Command

CPCURRENT( ) Function

CPDBF( ) Function

CREATE Command

CREATE FROM Command

CREATE QUERY Command

CREATE TABLE - SQL Command

CURVAL( ) Function

DELETE Command

DELETE - SQL Command

DELETED( ) Function

DISPLAY STRUCTURE Command

DISPLAY TABLES Command

EDIT Command

END TRANSACTION Command

EXPORT Command

FLUSH Command

GETFLDSTATE( ) Function

GETNEXTMODIFIED( ) Function

IMPORT Command

ISEXCLUSIVE( ) Function

ISREADONLY( ) Function

LIST TABLES Command

MEMLINES( ) Function

MLINE( ) Function

MODIFY GENERAL Command

MODIFY MEMO Command

MODIFY QUERY Command

MODIFY STRUCTURE Command

OLDVAL( ) Function

PACK Command

RECALL Command

REFRESH( ) Function

REMOVE TABLE Command

REPLACE Command

REPLACE FROM ARRAY Command

RENAME TABLE Command

ROLLBACK Command

SELECT Command

SELECT - SQL Command

SET ANSI Command

SET AUTOSAVE Command

SET DATASESSION Command

SET DELETED Command

SET FIELDS Command

SET NULL Command

SET OLEOBJECT Command

SET OPTIMIZE Command

SORT Command

SUM Command

SYS(2029) - Table Type

TABLEREVERT( ) Function

TABLEUPDATE( ) Function

TOTAL Command

TXNLEVEL( ) Function

UPDATE Command

UPDATE - SQL Command

USE Command

USED( ) Function

ZAP Command