Difference between revisions of "UNIQUEROWID()"
From Lianjapedia
(→Products) |
Yvonne.milne (Talk | contribs) |
||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return a unique row identifier for the current table or table in the specified workarea | Function to return a unique row identifier for the current table or table in the specified workarea | ||
− | |||
==Syntax== | ==Syntax== | ||
UNIQUEROWID([<expN>]) | UNIQUEROWID([<expN>]) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[ALIAS()]], [[DBF()]], [[FCOUNT()]], [[FIELD()]], [[FILTER | + | [[ALIAS()]], [[DBF()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[INDEXKEY()]], [[NDX()]], [[RECNO()]], [[SELECT()]], [[SEQNO()]], [[WORKAREA()]] |
− | + | ||
==Description== | ==Description== | ||
The UNIQUEROWID() function returns the name of a unique row identifier for the current table. The optional <expN> can be used to specify a workarea number. If there is a table open in the workarea number specified in <expN>, UNIQUEROWID() will return the name of a unique row identifier for that table. | The UNIQUEROWID() function returns the name of a unique row identifier for the current table. The optional <expN> can be used to specify a workarea number. If there is a table open in the workarea number specified in <expN>, UNIQUEROWID() will return the name of a unique row identifier for that table. | ||
− | |||
==Example== | ==Example== | ||
Line 22: | Line 18: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Cursor Functions]] |
− | + |
Latest revision as of 08:02, 7 December 2012
Contents
Purpose
Function to return a unique row identifier for the current table or table in the specified workarea
Syntax
UNIQUEROWID([<expN>])
See Also
ALIAS(), DBF(), FCOUNT(), FIELD(), FILTER(), INDEXKEY(), NDX(), RECNO(), SELECT(), SEQNO(), WORKAREA()
Description
The UNIQUEROWID() function returns the name of a unique row identifier for the current table. The optional <expN> can be used to specify a workarea number. If there is a table open in the workarea number specified in <expN>, UNIQUEROWID() will return the name of a unique row identifier for that table.
Example
use demo select state list state.state, (uniquerowid(select("state")))