QueryAppend

This function clears the query

Method Signature

QueryAppend(query1=[query], query2=[query])

Arguments

Argument	Type	Required	Description	Default
query1	query	true
query2	query	true

Examples

Builds a simple query using queryNew and queryAppend

Add new query to the end of the current query using queryAppend.

Run Example

names = queryNew( "empl_id,name", "integer,varchar", [ 
	[
		"empl_id" : 1239,
		"name" : "John"
	]
] );
newnames = queryNew( "empl_id,name", "integer,varchar", [
	[
		"empl_id" : 1501,
		"name" : "Jane"
	]
] );
queryAppend( names, newnames );
writeDump( names );

Additional Examples

Run Example

testQuery = queryNew( "name , age", "varchar , numeric", { 
	NAME : [
		"Susi",
		"Urs"
	],
	AGE : [
		20,
		24
	]
} );
newTestQuery = queryNew( "name , age", "varchar , numeric", [
	[
		"Smith",
		20
	],
	[
		"John",
		24
	]
] );
queryAppend( testQuery, newTestQuery );
writeDump( testQuery );

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

• QueryClear

• QuerySetRow

• QueryColumnArray

• QueryDeleteRow

• QuerySlice

• QueryRegisterFunction