|
Connection:-ExecuteUpdate - execute a Single SQL Update
|
|
Calling Sequence
|
|
connection:-ExecuteUpdate( stat, opts )
|
|
|
Parameters
|
|
|
connection
|
-
|
Connection module
|
|
stat
|
-
|
string; the SQL update to execute
|
|
opts
|
-
|
(optional) equation of the form commit=name
|
|
|
|
|
|
Description
|
|
|
•
|
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.
|
|
|
By passing commit=true, Maple automatically calls Commit after executing the update. By default, there is no commit after the update is executed.
|
|
|
|
Examples
|
|
Query some data from the database.
|
>
|
![driver := Database[LoadDriver]()](/support/helpjp/helpview.aspx?si=7889/file05677/math98.png)
|
|
>
|
 
|
|
![[]](/support/helpjp/helpview.aspx?si=7889/file05677/math106.png)
| (1) |
|
>
|
|
|
| (2) |
|
>
|
|
|
| (3) |
|
>
|
|
|
![matrix([[11, "chicken", 15, 2.10000000000000008], [12, "cow", 2, 513.]])](/support/helpjp/helpview.aspx?si=7889/file05677/math127.png)
| (4) |
|
|
Download Help Document
Was this information helpful?
