QueryAddRow

Adds rows to a query, either empty row(s) or you can add a row with data.

The number returned is the new row count of the query.

QueryAddRow( query [, numberOrData ] )

Returns: Number

Argument Description Default
query
query, required

Name of an executed query.

numberOrData
any, optional

Number of rows to add to the query or a struct/array containing the data to populate the row.

Examples:

  • queryAddRow(qry, 3);
  • queryAddRow(qry, [ "Susi", 20] );
  • queryAddRow(qry, { name: "Susi", age: 20 } );

1

Examples

myQuery    = queryNew( "id,name");
addedRows  = queryAddRow(myQuery, 3); // will return 3
queryAddRow(myQuery, [17,'added via array notation']);
anotherRow = queryAddRow(myQuery);    // will return 4
queryAddRow(myQuery, {
    id:18,
    name:'added via struct notation'
});
dump(myQuery);

See also