QueryNew

Creates an empty query (query object).

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

Returns: Query

Argument Description
columnNames
object, required

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

columnTypes
object, optional

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

data
any, optional

data to populate the new Query, an array of arrays or an 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