Online Help

ExecuteUpdate executes an SQL update over connection. The SQL string stat must contain only a single SQL statement that performs an UPDATE, INSERT, or DELETE, or an SQL statement that returns nothing. Passing any other statement to ExecuteUpdate is an error.

The value returned by ExecuteUpdate is an integer representing the update count (the number of rows changed by the update).

The opts argument can contain the following equation.

commit = true or false

By passing commit=true, Maple automatically calls Commit after executing the update. By default, there is no commit after the update is executed.

$\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{result}≔\mathrm{conn}:-\mathrm{ExecuteQuery}\left(''SELECT\; *\; FROM\; animals\; WHERE\; id\; >\; 10''\,'\mathrm{output}'='\mathrm{Array}'\right)\:$

$c:-\mathrm{ExecuteUpdate}\left(''INSERT\; INTO\; animals(\; id,\; name,\; number,\; mass\; )\; VALUES(\; 11,\; \text{'}chicken\text{'},\; 15,\; 2.1\; )''\right)$

$1$

$c:-\mathrm{ExecuteUpdate}\left(''INSERT\; INTO\; animals(\; id,\; name,\; number,\; mass\; )\; VALUES(\; 12,\; \text{'}cow\text{'},\; 2,\; 513\; )''\,\mathrm{commit}=\mathrm{true}\right)$

$1$

$c:-\mathrm{ExecuteQuery}\left(''SELECT\; *\; FROM\; animals\; WHERE\; id\; >\; 10''\,\mathrm{output}='\mathrm{Array}'\right)$

$\left[\begin{array}{cccc}11& ''chicken''& 15& 2.10000000000000008\\ 12& ''cow''& 2& 513.\end{array}\right]$