Difference between revisions of "USED()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
(3 intermediate revisions by 2 users not shown) | |||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[ALIAS()]], [[DATABASEEXISTS()]], [[DBF()]], [[INUSE()]], [[ | + | [[ALIAS()]], [[AUSED()]], [[DATABASEEXISTS()]], [[DBF()]], [[INUSE()]], [[ISRLOCKED()]], [[ISREADONLY()]], [[NDX()]], [[SELECT()]], [[SET EXCLUSIVE]], [[TABLEEXISTS()]], [[USE]] |
==Description== | ==Description== | ||
Line 25: | Line 25: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Cursor Functions]] |
− | + |
Latest revision as of 10:55, 4 February 2013
Contents
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.