SYSRESULTSET

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

Jump to: navigation, search

SYSRESULTSET

Class

SQL Applications


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

EXEC SQL
set("EXCLUSIVE") as Excl, time() as Time from sysresultset;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer