Difference between revisions of "SET SQLROWID"

From Recital Documentation Wiki
Jump to: navigation, search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET SQLROWID=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
To include a unique row identifier in SELECT * statements
 
To include a unique row identifier in SELECT * statements
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
SELECT, UNIQUEROWID()
+
[[SQL SELECT|SELECT]], [[:Category:SQL|SQL]]
  
  
Line 23: Line 16:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
set sql on
 
set sql on
 
set sqlrowid on
 
set sqlrowid on
select * from state.rdb where state = "M";</pre>
+
select * from state.rdb where state = "M";
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
[[Category:Set_Commands]]
+
[[Category:Set_Commands|SQLROWID]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 +
[[Category:SQL Set Commands]]

Latest revision as of 15:35, 25 November 2009

Purpose

To include a unique row identifier in SELECT * statements


Syntax

SET SQLROWID ON | OFF


See Also

SELECT, SQL


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 Server, Recital