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
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
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
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
Last updated
Was this helpful?