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 |
---|---|
Add records to a table. |
|
Copy the contents of a text file to a memo field. |
|
Clear data from fields. |
|
Continue the previous LOCATE. |
|
Mark records for deletion. |
|
Return a table filter expression specified in SET FILTER. |
|
Move a record pointer. |
|
Search an indexed table without moving the record pointer. |
|
Append new records to a table. |
|
Determine if an expression is blank. |
|
Search and index tag or an index file for an index key. |
|
Sequentially search a table for a specified logical expression. |
|
Search a table for the first record with a field matching a specified expression |
|
Update data in fields with values from a variable array. |
|
Search a table for a record whose index key matches a general expression. |
|
Search an indexed table for a record whose index key matches a specified expression. |
|
Specify a collate sequence for character fields in subsequent indexing and sorting operations. |
|
Specify a condition that records must meet to be accessible. |
|
Specify access to a range of records based on their index keys. |
|
Determine where the record pointer is positions after an unsuccessful search for a record. |
|
Establish a relation between two open tables. |
|
Move the record pointer forward or backward in a table. |
|
Update records in a table with new values. |