SYSRESULTSET

From Recital Documentation Wiki
Revision as of 15:57, 22 December 2009 by Yvonnemilne (Talk | contribs)

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

Purpose

Used to return the singleton result from any Recital expression


See Also

DATA TYPES, SELECT, SYSTEM TABLES


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.

The SYSRESULTSET system table is used to return the singleton result from any Recital expression.


Column Data Type Width
<expression1> <result1 type> <result1 width>
<expression256> <result256 type> <result256 width>


An error will occur if any expression is specified that returns more than one result.


Example

select set("EXCLUSIVE") as Excl, time() as Time from sysresultset


Products

Recital, Recital Server