Difference between revisions of "INUSE()"

From Lianjapedia
Jump to: navigation, search
 
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Function to determine if a table is open
 
Function to determine if a table is open
 
  
 
==Syntax==
 
==Syntax==
 
INUSE(<expC>)
 
INUSE(<expC>)
 
  
 
==See Also==
 
==See Also==
[[DBF()]], [[NDX()]], [[NETERR()]], [[SET CACHELOAD]], [[SET DCACHE]], [[SET EXCLUSIVE]], [[USE]], [[USED()]]
+
[[DBF()]], [[NDX()]], [[SET EXCLUSIVE]], [[USE]], [[USED()]]
 
+
  
 
==Description==
 
==Description==
 
The INUSE() function checks if a table with the alias name specified in <expC> is open in any workarea.  The INUSE() functions returns .T. if a table is open, .F. if not.  The alias can be specified in the USE command.  If not specified, the table basename is used
 
The INUSE() function checks if a table with the alias name specified in <expC> is open in any workarea.  The INUSE() functions returns .T. if a table is open, .F. if not.  The alias can be specified in the USE command.  If not specified, the table basename is used
 
  
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
// The demo view bridge opens
+
? inuse("customers")
// the tables customer, accounts,
+
// state and products in workareas 1 – 4
+
use demo
+
? inuse("customer")
+
 
.T.
 
.T.
? inuse("product")
+
? inuse("products")
 
.T.
 
.T.
 
</code>
 
</code>
  
 
==Products==
 
Recital Server, Recital
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Table Basics]]
+
[[Category:Cursor Functions]]
[[Category:Table Basics Functions]]
+

Latest revision as of 10:53, 4 February 2013

Purpose

Function to determine if a table is open

Syntax

INUSE(<expC>)

See Also

DBF(), NDX(), SET EXCLUSIVE, USE, USED()

Description

The INUSE() function checks if a table with the alias name specified in <expC> is open in any workarea. The INUSE() functions returns .T. if a table is open, .F. if not. The alias can be specified in the USE command. If not specified, the table basename is used

Example

? inuse("customers")
.T.
? inuse("products")
.T.