QuerySetRow

Adds or updates a row in a query based on the provided row data and position.

Method Signature

QuerySetRow(query=[query], rowNumber=[integer], rowData=[any])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query object to which the row should be added or updated.
rowNumber	integer	false	Optional position of the row to update; if omitted or zero, a new row will be added.	0
rowData	any	true	A struct or array containing data for the row.

Examples

Builds a simple query using queryNew and querySetRow

Sets third row of query overwriting news entry

Run Example

news = queryNew( "id,title", "integer,varchar", [ 
	{
		"id" : 1,
		"title" : "Dewey defeats Truman"
	},
	{
		"id" : 2,
		"title" : "Men walk on Moon"
	},
	{
		"id" : 3,
		"title" : "Nixon Resigns"
	},
	{
		"id" : 4,
		"title" : "The Berlin Wall falls"
	}
] );
querySetRow( news, 3, {
	"id" : 5,
	"title" : "The internet is born"
} );
writeDump( news );

Builds a simple query using queryNew and someQuery.setRow member syntax

Sets third row of query overwriting news entry

Run Example

news = queryNew( "id,title", "integer,varchar", [ 
	{
		"id" : 1,
		"title" : "Dewey defeats Truman"
	},
	{
		"id" : 2,
		"title" : "Men walk on Moon"
	},
	{
		"id" : 3,
		"title" : "Nixon Resigns"
	},
	{
		"id" : 4,
		"title" : "The Berlin Wall falls"
	}
] );
news.setRow( 3, {
	"id" : 5,
	"title" : "The internet is born"
} );
writeDump( news );

Additional Examples

Run Example

testQuery = queryNew( "id,name", "integer,varchar", [ 
	{
		"id" : 1,
		"name" : "jenifer"
	},
	{
		"id" : 2,
		"name" : "ajay"
	},
	{
		"id" : 3,
		"name" : "john"
	},
	{
		"id" : 4,
		"name" : "smith"
	}
] );
querySetRow( testQuery, 3, {
	"id" : 5,
	"name" : "alpha"
} );
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

• QueryColumnArray

• QueryDeleteRow

• QueryAppend

• QuerySlice

• QueryRegisterFunction