SQLVALUES()

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