Difference between revisions of "ROWID"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 20: Line 20:
 
<code lang="recital">
 
<code lang="recital">
 
// Optimized update accounts row 35 with a 15% commission charge
 
// Optimized update accounts row 35 with a 15% commission charge
EXEC SQL
+
UPDATE accounts SET ord_value=ord_value*1.15, due_date = date()+30 WHERE ROWID=35
UPDATE accounts
+
SET ord_value=ord_value*1.15, due_date = date()+30
+
WHERE ROWID=35;
+
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Pseudo Columns]]
 
[[Category:Pseudo Columns]]

Latest revision as of 15:00, 4 July 2011

Purpose

Return a number identifying the row’s physical stored position in the table


Syntax

ROWID


See Also

PSEUDO COLUMNS, INSERT, SELECT, UPDATE


Description

A Pseudo Column behaves like a table column, but is not actually stored in the table. You can select from Pseudo Columns, but they can not be updated. Pseudo Columns provide extra information about a SELECT row set.

The ROWID Pseudo Column will return a number identifying the row’s physical stored position in the table. The ROWID Pseudo Column can be used to perform singleton selects, or optimize updates of a known ROWID.


Example

// Optimized update accounts row 35 with a 15% commission charge
UPDATE accounts SET ord_value=ord_value*1.15, due_date = date()+30 WHERE ROWID=35


Products

Recital, Recital Server