Difference between revisions of "USED()"

Latest revision as of 10:55, 4 February 2013

Purpose

Function to determine if a table is open

Syntax

USED([<expN> | <expC>])

See Also

ALIAS(), AUSED(), DATABASEEXISTS(), DBF(), INUSE(), ISRLOCKED(), ISREADONLY(), NDX(), SELECT(), SET EXCLUSIVE, TABLEEXISTS(), USE

Description

The USED() function with no parameter specified, returns .T. if there is a table open in the current workarea and .F. if the current workarea is empty. The <expN> is a numeric expression giving a workarea number in which to check for an open table. The <expC> is a character expression giving a workarea letter, (A-Z/a-z excluding M/m) or a table alias in which to check for an open table. The alias can be specified in the USE command. If not specified, the table basename is used.

Example

? select()
         1
? used()
.T.
? used("products")
.T.
? used(5)
.F.