SQLVALUES()

From Lianjapedia
Revision as of 22:33, 10 December 2012 by Admin (Talk | contribs)

Jump to: navigation, search

Purpose

Function to return the single row result of an SQL statement

Syntax

SQLVALUES(<SQL statement>)

See Also

SELECT

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")