Difference between revisions of "UNIQUEROWID()"
From Recital Documentation Wiki
		
		
		
| Yvonnemilne  (Talk | contribs) | Yvonnemilne  (Talk | contribs)  | ||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| ==Class== | ==Class== | ||
| Data Connectivity | Data Connectivity | ||
| Line 34: | Line 31: | ||
| [[Category:Documentation]] | [[Category:Documentation]] | ||
| [[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Fields and Records]] | ||
| + | [[Category:Fields and Records Functions]] | ||
Revision as of 11:36, 3 June 2009
Class
Data Connectivity
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(), SELECT(), 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 Database Server, Recital Mirage Server, Recital Terminal Developer
