Syntax

DBExec-return

This JSON is the data structure returned by the DBExec() function; this JSON data structure is also returned when executing SQL statements using the exec() method of objects created by the Dial() function.

Attributes

Name	Type	Description
columns	array	Column names of the queried data, string array.
values	array	The specific data queried, where each data item corresponds to the column names. The values field is a two-dimensional array, with each element being an array representing one data record.

See Also

DBExec Dial

Remarks

Example of querying data from database:


            json
            
            
{
    "columns":["TS","HIGH","OPEN","LOW","CLOSE","VOLUME"],
    "values":[
        [1518970320000,100,99.1,90,100,12345.6],
        [1518960320000,100,99.1,90,100,12345.6]
    ]
}