SQLVALUES()
From Lianjapedia
Revision as of 11:51, 10 December 2012 by Yvonne.milne (Talk | contribs)
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")