QueryNew()

Creates an empty query (query object).

QueryNew( columnNames=object, columnTypes=object, data=any );

Returns: Query

Argument Description
columnNames
object, required

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

Alias: names, columns, columnList
columnTypes
object, optional

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

Alias: types, columnTypeList
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); 
	qry= queryNew( "name , age" , "varchar , numeric" , [ [ "Susi" , 20 ] , [ "Urs", 24 ] ]);
  	dump(qry);
 	qry= queryNew( "name , age" , "varchar , numeric" , [ { name: "Susi" , age: 20 }, { name: "Urs" , age: 24 } ] );
  	dump(qry);

See also