Difference between revisions of "SQLVALUES()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
Line 20: | Line 20: | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
+ | [[Category:Data Analysis Functions]] | ||
+ | [[Category:Lianja VFP Extensions]] | ||
+ | [[Category:VFP Function Extensions]] |
Revision as of 22:33, 10 December 2012
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")