Alias_Table subroutine

Creates a temporary synonym (an alias) for an existing table. The permanent database definition is not altered.

Alias_Table(locationlist, database, tablename, aliasname)

The Alias_Table subroutine has the following parameters.

ParameterDescription
locationlistStates the location of the existing table. Can be specified in either of the following ways:

[ location ]
[ location, table_type ]
[ location, table_type, control_table_path ]
volume_pointer_name


Typically, this value will be the path to a directory containing Native Tables.
databaseDatabase to which the table belongs. If null, the current database is used. Use the List_Tables command to determine the database for a specific table. Note that most of the system tables belong to the "GLOBAL" database.
tablenameName of the table for which you are creating an alias. Use the form that is returned by List_Volume. If List_Volume shows that the table name is qualified (SALLY@TABLENAME, for example), you must also qualify the table name.
aliasnameThe alias for the table. If Alias_Table is successful, the specified table will be accessible using the alias name.


Caution: Do not use the name of a system table for the alias name parameter. Use Get_Status() to check if Alias_Table failed.|

Note: All parameters are passed by reference, not by value.

/* The alias "BACKUP" is used for the CAR_PARTS table in the volume E:\DAT in the database INVENTORY. */

Declare Subroutine Alias_Table, Set_Status, Msg
Declare Function Get_Status

Alias_Table ("E:\DAT", "INVENTORY", "CAR_PARTS", "BACKUP")
if Get_Status() then
  Msg(@window, "Unable to alias the CAR_PARTS table.")
  Set_Status (0)
end
  • guides/programming/programmers_reference_manual/alias_table.txt
  • Last modified: 2024/10/14 18:18
  • by 127.0.0.1