Share via


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