SQLVALUES()
From Lianjapedia
Contents
Purpose
Function to return the single row result of an SQL statement
Syntax
SQLVALUES(<SQL statement>)
See Also
Description
The SQLVALUES() function executes the <SQL statement> and returns the result as a string. The required <SQL statement> cannot return multiple rows. Multiple values are returned as a comma separated list.
Example
open database southwind cTotal = sqlvalues("select max(available), min(available) from example")