CURRVAL

From Recital Documentation Wiki
Revision as of 12:31, 13 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

CURRVAL

Class

Pseudo Columns


Purpose

Return the current sequence number from the specified table


Syntax

CURRVAL


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 cannot be updated. Pseudo Columns provide extra information about a SELECT row set.

The CURRVAL Pseudo Column will return the current sequence number from the specified table. Sequence numbers can be used for primary and unique index keys.


Example

// config.db
set sql to recital
set sql on
// end of config.db
 
CREATE TABLE cust (acc_num INT , acc_name char(20)); 
INSERT INTO cust (acc_num, acc_name) VALUES (NEXTVAL, "Smith");
INSERT INTO cust (acc_name) VALUES ("Brown");
INSERT INTO cust (acc_num, acc_name) VALUES (CURRVAL+2, "Jones");
SELECT * from cust;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer