QueryNew

Creates an empty query (query object).

Returns: query

Usage

QueryNew( columnNames [, columnTypes [, data ] ] )

Arguments

Argument Description
columnNames
(object, required)

column names for the query created, allowed are comma-delimited string lists or a array.

columnTypes
(object, optional)

column types for the query created, allowed are comma-delimited string lists or a array.

data
(any, optional)

data to populate the new Query, a array of arrays or a array of structs. Example usage: queryNew("name,age","varchar,numeric",[["Susi",20],["Urs",24]]); queryNew("name,age","varchar,numeric",[[name:"Susi",age:20],[name:"Urs",age:24]]); queryNew("name,age","varchar,numeric",{name:["Susi","Urs"],age:[20,24]});

Examples

testQuery = queryNew( "name , age" , "varchar , numeric" , { name: [ "Susi" , "Urs" ] , age: [ 20 , 24 ] } );
  dump(testQuery);

See also