SQLVALUES()

SQLVALUES()

Class

Data Connectivity

Purpose

Function to return the single row result of an SQL statement

Syntax

SQLVALUES(<SQL statement>)

See Also

AVERAGE, COUNT, SUM, TOTAL, AMAX(), AMIN(), AVGVALUES(), CNTVALUES(), MAX(), MAXVALUES(), MIN(), MINVALUES(), SUMVALUES()

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 Database Server, Recital Mirage Server, Recital Terminal Developer