query.setCell()

edit

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

You can also use query.addRow() to add a new row with data.


		query.setCell( column_name=string, value=any, row_number=number )

Returns: Query

Argument	Description
column_name _{string, required}	edit Name of the column to update _{Alias: columnName}
value _{any, required}	edit New value for the cell
row_number _{number, optional}	edit Which row to update, defaults to the the last row in the query _{Alias: row, number}

Argument

Description

column_name

_{string,

required}

edit

Name of the column to update

_{Alias: columnName}

value

_{any,

required}

edit

New value for the cell

row_number

_{number,

optional}

edit

Which row to update, defaults to the the last row in the query

_{Alias: row, number}

edit

q = queryNew( "id,name");
q.addRow();

q.setCell("id", 1, 1);
q.setCell("name", "one", 1);

dump(q);