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

Name of the column to populate.

Alias: columnName

value
any, required

The value to populate the query cell with.

row_number
number, optional

Query row number to populate.

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