open

Syntax

OPEN facsname

OPEN facsname NORESET

OPEN facsname POINTER = number

Arguments

facsname: FACS name

number: integer

Meaning

Opens the file that you declared as the FACS buffer name earlier in the procedure. The index and record pointers are moved to the starting position. Collections will initialize all database variables for this database table to null. The table and accompanying variables then become available for FACS operations.

With the OPEN instruction the system variable &E is set to an error code. The value 0 means that the opening procedure was successful. Any other value means that an error occurred. The meaning of those values can be found in the error code list.

If the FACS buffer has already been opened, Collections will not open it again, but just resets it in memory, unless you use OPEN ... NORESET. In that case, the index and record pointers will remain unchanged.

To use the selection in a saved search (aka pointer file) when reading from a FACS buffer, use OPEN ... POINTER and enter the number of the saved search you want to use (see example).

Example

open BOOK pointer = 1

Result

The search statement in the saved search with the number 1 is used to read from the previously declared FACS buffer BOOK.

See also

Click here for general information about FACS.