QuerySetCell()

Sets a cell to a value. If no row number is specified, the cell on the last row is set.

You can add an entire row with data with QueryAddRow().

QuerySetCell( query=query, column_name=string, value=any, row_number=number );

Returns: Boolean

Argument Description Default
query
query, required

Name of an executed query.

Alias: query

column_name
string, required

Alias: columnName

value
any, required
row_number
number, optional

Alias: row, number

-9999

Examples

q = queryNew( "id,name");
QueryAddRow(q);
QuerySetCell(q, "id", 1, 1);
QuerySetCell(q, "name", "one", 1);
dump(q);

See also