UpdateRow sends the row changes made by UpdateData to the database.

To update a row, set the new values by calling UpdateData and then submit these updates by calling UpdateRow.  Changing the current row before calling UpdateRow discards any values set with UpdateData.

Maple can automatically determine the type of the column and convert data; 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.

An element can be set to SQL NULL by passing 'SQLNULL' for data.

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 (assuming the JDBC driver is standards-compliant). Particular JDBC Drivers and databases may allow a wider range of updatable tables and thus Result modules.

Updates made to a row may not be visible in the current Result module.  Issuing another query may be necessary to see the changes.

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$$\mathrm{res}≔\mathrm{conn}:-\mathrm{ExecuteQuery}\left(''SELECT\; id,name,number,mass\; FROM\; animals''\right)\:$$\mathrm{res}:-\mathrm{Next}\left(\right)$

$\mathrm{true}$

$\mathrm{res}:-\mathrm{GetData}\left(2\right)$

$''fish''$

$\mathrm{res}:-\mathrm{GetData}\left(3\right)$

$100$

$\mathrm{res}:-\mathrm{GetData}\left(4\right)$

$0.0100000000000000002$

$\mathrm{res}:-\mathrm{UpdateData}\left(2\,''chicken''\right)\;$$\mathrm{res}:-\mathrm{UpdateData}\left(3\,6\right)\;$$\mathrm{res}:-\mathrm{UpdateData}\left(4\,2.5\right)$

$\mathrm{res}:-\mathrm{GetData}\left(2\right)$

$''fish''$

$\mathrm{res}:-\mathrm{GetData}\left(3\right)$

$100$

$\mathrm{res}:-\mathrm{GetData}\left(4\right)$

$0.0100000000000000002$

$\mathrm{res}:-\mathrm{UpdateRow}\left(\right)$

$\mathrm{res}≔\mathrm{conn}:-\mathrm{ExecuteQuery}\left(''SELECT\; id,name,number,mass\; FROM\; animals''\right)\:$$\mathrm{res}:-\mathrm{Next}\left(\right)$

$\mathrm{true}$

$\mathrm{res}:-\mathrm{GetData}\left(2\right)$

$''chicken''$

$\mathrm{res}:-\mathrm{GetData}\left(3\right)$

$6$

$\mathrm{res}:-\mathrm{GetData}\left(4\right)$

$2.50000000000000000$