Record Manipulation Language

These commands and functions make it possible for you to select records within a table or position the record pointer.

Use	To
APPEND FROM Command	Add records to a table.
APPEND MEMO Command	Copy the contents of a text file to a memo field.
BLANK Command	Clear data from fields.
CONTINUE Command	Continue the previous LOCATE.
DELETE - SQL Command	Mark records for deletion.
FILTER( ) Function	Return a table filter expression specified in SET FILTER.
GO | GOTO Command	Move a record pointer.
INDEXSEEK( ) Function	Search an indexed table without moving the record pointer.
INSERT - SQL Command	Append new records to a table.
ISBLANK( ) Function	Determine if an expression is blank.
KEYMATCH( ) Function	Search and index tag or an index file for an index key.
LOCATE Command	Sequentially search a table for a specified logical expression.
LOOKUP( ) Function	Search a table for the first record with a field matching a specified expression
REPLACE FROM ARRAY Command	Update data in fields with values from a variable array.
SEEK Command	Search a table for a record whose index key matches a general expression.
SEEK( ) Function	Search an indexed table for a record whose index key matches a specified expression.
SET COLLATE Command	Specify a collate sequence for character fields in subsequent indexing and sorting operations.
SET FILTER Command	Specify a condition that records must meet to be accessible.
SET KEY Command	Specify access to a range of records based on their index keys.
SET NEAR Command	Determine where the record pointer is positions after an unsuccessful search for a record.
SET RELATION Command	Establish a relation between two open tables.
SKIP Command	Move the record pointer forward or backward in a table.
UPDATE - SQL Command	Update records in a table with new values.

See Also

Other Resources

Databases

Language Categories