Detach_Table subroutine [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.

====== Detach_Table subroutine    ======


 
==== Description ====
 
Temporarily prevents access to a single table or list of tables by removing them from the current database. The permanent database definition is not altered.
 
==== Syntax ====
 
**Detach_Table**(//tablelist//)
 
==== Parameters ====
 
The Detach_Table subroutine has the following parameters. Use Get_Status() to check for an error.

^Parameter^Description^
|//tablelist//|Contains a single table name or a @FM-delimited list of table names to detach.||

 
==== See Also ====
 
[[attach_table|Attach_Table]]
 
==== Example ====
 
<code>
* Detaches the OUTSTANDING table.

Detach_Table("OUTSTANDING")
if Get_Status(ErrCodes) then
  GoSub ErrorHandling
end

/* Detaches the CAR_PARTS and CAR_ORDERS tables from the current database. */

TableList = ""
TableList <1> = "CAR_PARTS"
TableList <2> = "CAR_ORDERS"

Detach_Table(TableList)
if Get_Status(ErrCodes) then
  GoSub ErrorHandling
end
 
 
</code>