OPEN_INT¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to replace the OPEN command in DataFlex. It can be useful when accessing tables that are not in the current filelist. To access these tables, the INT and FD files must be in the directory. From there, all that is needed is to open the table using this command under an alias name. If the command is executed successfully then the table can be queried normally as if it were a standard table. Note that if the desired table is already in the filelist or doesn’t have an INT file then this command will act as a normal open command.

Syntax

OPEN_INT {variable} as {aliasName}

Parameter	Description
variable	The name of the int file without the extension.
aliasName	The alias name being used to query this table.

Example

OPEN_INT "customer" as Customer

For_All Customer by Index.1 do
    Showln Customer.FirstName
End_For_All