Difference between revisions of "ALIAS()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
| − | [[DBF()]], [[SELECT]], [[SELECT()]], [[USE]], [[WORKAREA()]] | + | [[AUSED()]], [[DBF()]], [[SELECT]], [[SELECT()]], [[USE]], [[WORKAREA()]] |
==Description== | ==Description== | ||
The ALIAS() function returns, as a character string in upper case, the alias name of the table in the currently selected workarea, or a null string if no table is active. The optional parameter <expN> can be used to specify the workarea number in which the ALIAS() function should operate. | The ALIAS() function returns, as a character string in upper case, the alias name of the table in the currently selected workarea, or a null string if no table is active. The optional parameter <expN> can be used to specify the workarea number in which the ALIAS() function should operate. | ||
| + | |||
| + | Note: for the use of UI Element Alias Names, see [[UI_Presentation_Rules#Using_UI_Element_Alias_Names|UI Presentation Rules:Using UI Element Alias Names]]. For user-defined commands, see the [[ALIAS]] command. | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | use | + | use customers alias cust |
? alias() | ? alias() | ||
| − | + | CUST | |
| − | + | ||
| − | + | ||
? dbf() | ? dbf() | ||
| − | + | customers.dbf | |
</code> | </code> | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Cursor Functions]] | ||
Latest revision as of 12:54, 4 December 2017
Contents
Purpose
Function to return an alias name
Syntax
ALIAS([<expN>])
See Also
AUSED(), DBF(), SELECT, SELECT(), USE, WORKAREA()
Description
The ALIAS() function returns, as a character string in upper case, the alias name of the table in the currently selected workarea, or a null string if no table is active. The optional parameter <expN> can be used to specify the workarea number in which the ALIAS() function should operate.
Note: for the use of UI Element Alias Names, see UI Presentation Rules:Using UI Element Alias Names. For user-defined commands, see the ALIAS command.
Example
use customers alias cust ? alias() CUST ? dbf() customers.dbf
