SQLVALUES()

From Recital Documentation Wiki
Revision as of 11:55, 22 June 2010 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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