Difference between revisions of "ALIAS()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return an alias name | Function to return an alias name | ||
| − | |||
==Syntax== | ==Syntax== | ||
ALIAS([<expN>]) | ALIAS([<expN>]) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[DBF | + | [[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. | ||
| − | |||
==Example== | ==Example== | ||
| Line 26: | Line 22: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Revision as of 07:43, 10 February 2012
Contents
Purpose
Function to return an alias name
Syntax
ALIAS([<expN>])
See Also
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.
Example
use demo ? alias() CUSTOMER ? alias(2) ACCOUNTS ? dbf() customer.rdb
