Difference between revisions of "DBUSED()"
From Lianjapedia
(→Products) |
Yvonne.milne (Talk | contribs) |
||
(6 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to check whether a database is open. | Function to check whether a database is open. | ||
− | |||
==Syntax== | ==Syntax== | ||
DBUSED(<expC>) | DBUSED(<expC>) | ||
− | |||
==See Also== | ==See Also== | ||
[[ADATABASES()]], [[ADIR()]], [[ALIAS()]], [[CLOSE DATABASES]], [[COPY DATABASE]], [[DATABASE()]], [[DBF()]], [[DISPLAY SCHEMAS]], [[DISPLAY STATUS]], [[GETENV()]], [[LIST SCHEMAS]], [[LIST STATUS]], [[OPEN DATABASE]], [[SET FILECASE]], [[SET SQL]], [[USE]], [[USED()]] | [[ADATABASES()]], [[ADIR()]], [[ALIAS()]], [[CLOSE DATABASES]], [[COPY DATABASE]], [[DATABASE()]], [[DBF()]], [[DISPLAY SCHEMAS]], [[DISPLAY STATUS]], [[GETENV()]], [[LIST SCHEMAS]], [[LIST STATUS]], [[OPEN DATABASE]], [[SET FILECASE]], [[SET SQL]], [[USE]], [[USED()]] | ||
− | |||
==Description== | ==Description== | ||
The DBUSED() function is used to check whether the database whose name is specified in <expC> is open. If the database is open, DBUSED() returns True (.T.), if not it returns False (.F.). | The DBUSED() function is used to check whether the database whose name is specified in <expC> is open. If the database is open, DBUSED() returns True (.T.), if not it returns False (.F.). | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | + | open database hr exclusive | |
− | + | ? dbused("hr") | |
.T. | .T. | ||
− | + | close databases | |
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
− | [[Category: | + | [[Category:Database Functions]] |
− | + |
Latest revision as of 12:15, 4 February 2013
Contents
Purpose
Function to check whether a database is open.
Syntax
DBUSED(<expC>)
See Also
ADATABASES(), ADIR(), ALIAS(), CLOSE DATABASES, COPY DATABASE, DATABASE(), DBF(), DISPLAY SCHEMAS, DISPLAY STATUS, GETENV(), LIST SCHEMAS, LIST STATUS, OPEN DATABASE, SET FILECASE, SET SQL, USE, USED()
Description
The DBUSED() function is used to check whether the database whose name is specified in <expC> is open. If the database is open, DBUSED() returns True (.T.), if not it returns False (.F.).
Example
open database hr exclusive ? dbused("hr") .T. close databases