SET SQLROWID
From Recital Documentation Wiki
Revision as of 13:28, 10 March 2009 by Yvonnemilne (Talk | contribs)
Contents
SET SQLROWID
Class
SQL Applications
Purpose
To include a unique row identifier in SELECT * statements
Syntax
SET SQLROWID ON | OFF
See Also
SELECT, UNIQUEROWID()
Description
The SET SQLROWID ON | OFF command is used to determine whether a unique row identifier in should be included in SELECT * statements. If SET SQLROWID is ON, the unique row identifier will be included, if SET SQLROWID is OFF, only the fields from the table will be included.
Example
set sql on set sqlrowid on select * from state.rdb where state = "M";
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
