Difference between revisions of "ROWID"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (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 | ||
| − | + | 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 | + | 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
