Using ATTACHTABLE_SUB (Functions/Subroutines/Programs) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Using ATTACHTABLE_SUB (Functions/Subroutines/Programs) ======

======   ======

==== Created at 14 NOV 1996 02:10PM ====




**ATTACHTABLE_SUB**

**ATTACHTABLE_SUB( volumeName, tableList, options )**

** Using ATTACHTABLE_SUB**

**ATTACHTABLE_SUB** attaches tables, making them available for subsequent processing. The subroutine can attach all available tables on a volume, or a selected list only. A table is available to **ATTACHTABLE_SUB** if it belongs to the current application or if it is global.

You can use a table alias (Qfile) to attach a table that belongs to another application. However, if the second application has a password, the alias definition (in the **SYSALIAS** table) must include the password. Add it to the second attribute of the definition. For example:

SYSALIAS

SAMPLE**,MYPASSWORD******

SAMPLE_CUSTOMERS

For more information about creating an alias for a table, see "Creating an alias (synonym) for a table" in Chapter 22 of the Advanced Revelation //User's Guide//.

If a table is qualified with a user name, you can attach it by including the appropriate user prefix. For details, see "Table names and users (qualified table names)" in Chapter 22 of the Advanced Revelation //User's Guide//.

** volumeName**

The name of a valid volume, either a volume defined using the SetVolume window, or the name of an operating system path where there are Advanced Revelation tables. If //tableList// //// is null, all qualifying tables on the volume are attached. If no //volumeName// //// is provided, the default data volume is assumed.

** tableList**

An array (**@FM**-delimited) of tables to attach. If this parameter is null, all qualifying tables on the volume are attached. By default, the subroutine attaches the dictionary, the data portion of the table, and any indexes (the !file). To attach only one portion of the file, use these prefixes on the table name:

|**Prefix**      |**Meaning**                                                                                                                  |
|**DICT**.       |Attach only the dictionary portion of the table.                                                                             |
|**DATA**.\\ \\  |Attach only the data portion of the file, not the dictionary. (This also attaches the !file if the table is indexed.) \\ \\  |

If there are two tables of the same name, but one belongs to the current application and the other is global, the table belonging to the application is attached. You can attach the table **REVMEDIA**, but only if you are in the **SYSPROG **application.

** options**

|**Option**|**Meaning**                                                                                                                      |
|**A**     |(announce). Posts a message in the status line if the file being attached was previously attached from another volume.\\ \\ ** **|

**Values returned**

If an error has occured, the system variable //status(// //)// is set to 1, otherwise //status( )// is zero. Specific errors are returned in //@file.error//. Multiple errors are delimited with **@RM**. Possible values are:

|**Error**|**Meaning**                                                                                           |
|W504     |Invalid table name, or attempt to attach a table from another application without the proper password.|
|109      |Invalid volume name.\\ \\ ** **                                                                       |

**Example of ATTACHTABLE_SUB**

/* attaches a list of tables */

volume = "SAMPLE"

tableList = ""

tableList<1> = "SAMPLE_CUSTOMERS" /* data, dict, and index */

tableList<2> = "DATA.CAR_PARTS" /* data and index only */

tableList<3> = "DICT.CAR_ORDERS" /* dict only */

 

options = "A" /* Announce option */

 

call ATTACHTABLE_SUB(volume, tablelist, options )

 

if len( status() ) then

 call fsmsg() /* display messages */

end

** **