Difference between revisions of "UNIQUEROWID()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→Products) |
||
| (3 intermediate revisions by 2 users 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 | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[ALIAS()]], [[DBF()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[FMT()]], [[INDEXKEY()]], [[NDX()]], [[READVAR()]], [[SELECT()]], [[WORKAREA()]] | + | [[ALIAS()]], [[DBF()]], [[FCOUNT()]], [[FIELD()]], [[FILTER()]], [[FMT()]], [[INDEXKEY()]], [[NDX()]], [[READVAR()]], [[RECNO()]], [[SELECT()]], [[SEQNO()]], [[WORKAREA()]] |
| Line 28: | Line 24: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Fields and Records]] | [[Category:Fields and Records]] | ||
[[Category:Fields and Records Functions]] | [[Category:Fields and Records Functions]] | ||
Latest revision as of 16:44, 8 December 2009
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(), FMT(), INDEXKEY(), NDX(), READVAR(), 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")))
Products
Recital, Recital Server
