QueryClear

This function clears the query

Method Signature

QueryClear(query=[query])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query to clear

Examples

queryClear member function

Description of the code example

Run Example

heroes = queryNew( "id,Name", "integer,varchar", [ 
	{
		"id" : 1,
		"Name" : "Bruce Banner"
	},
	{
		"id" : 2,
		"Name" : "Tony Stark"
	},
	{
		"id" : 3,
		"Name" : "Bobby Drake"
	},
	{
		"id" : 4,
		"Name" : "Jean Grey"
	}
] );
writeOutput( "Query with records<br />" );
writeDump( heroes );
writeOutput( "The same query, but cleared<br />" );
writeDump( heroes.clear() );

Result: A query with 4 heroes, then a query with none

Additional Examples

Run Example

qry = queryNew( "name, age", "varchar, integer", [ 
	[
		"Susi",
		20
	],
	[
		"Urs",
		24
	],
	[
		"Smith",
		21
	],
	[
		"John",
		26
	]
] );
writeOutput( "Before QueryClear :" );
writeDump( qry );
result = queryClear( qry );
writeOutput( "After QueryClear :" );
writeDump( qry );

Related

• QueryRecordCount

• QueryColumnList

• QueryRowSwap

• QuerySort

• QueryEach

• QueryKeyExists

• QueryColumnCount

• QueryReduce

• QueryCurrentRow

• QueryColumnData

• QueryRowData

• QueryFilter

• QueryAddRow

• QueryNew

• QueryReverse

• QueryPrepend

• QueryColumnExists

• QueryAddColumn

• QueryGetCell

• QueryGetResult

• QueryMap

• QueryEvery

• QueryRecordCount

• QuerySome

• QueryDeleteColumn

• QuerySetCell

• QueryInsertAt

• QuerySetRow

• QueryColumnArray

• QueryDeleteRow

• QueryAppend

• QuerySlice

• QueryRegisterFunction