InsertRow allows a new row of data to be inserted in to the table. InsertRow accepts arguments in two different formats.

The index form inserts the first argument to InsertRow into the first column of the table, the second argument into the second column, and so forth. If there are more columns than arguments specified, the unspecified columns are given SQL NULL as values.

The equations form inserts value into the row named option. Any unassigned columns are assigned a value of SQL NULL.

Maple can automatically determine the type of a column and convert the input argument; however, this requires querying the type of the column.  To avoid this overhead, the type can be specified using an explicit cast.  For more information, see conversions.

When using the index form of InsertRow, you can set an element to SQL NULL by passing 'SQLNULL' as the argument corresponding to that column.

Not all Result modules can be updated.  Only Result modules representing tables containing data from a single table (no joins) and a column of primary keys are guaranteed to be updatable.  Particular JDBC Drivers and databases may allow a wider range of updatable tables and thus Result modules.

InsertRow does not return anything.