SQLVALUES()

From Recital Documentation Wiki
Revision as of 16:33, 7 December 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

Purpose

Function to return the single row result of an SQL statement


Syntax

SQLVALUES(<SQL statement>)


See Also

CONNECTED(), GATEWAY(), LOGIN, LOGOUT, MODIFY GATEWAY, SET GATEWAY


Description

The SQLVALUES() function executes the <SQL statement> and returns the result as a string. The required <SQL statement> cannot return multiple rows. If a SELECT statement is specified it must be a singleton select.

The SQLVALUES() function can only be used with an active gateway connection.


Example

login "Oracle","node","user","Password"
// Count the number of records in the employee table
cTotal = sqlvalues("SELECT COUNT(*) FROM emp")
total=val(cTotal)
// Count the number of records in the employee table matching the key "Mr"
cTotal = sqlvalues("SELECT COUNT(*) FROM emp WHERE title = 'Mr'")


Products

Recital, Recital Server