|
Result:-UpdateData - set the value to which an element will be changed
|
|
Calling Sequence
|
|
result:-UpdateData( index, data )
|
|
|
Parameters
|
|
|
result
|
-
|
Result module
|
|
index
|
-
|
string or integer; the column to be updated
|
|
data
|
-
|
the new value
|
|
|
|
|
|
Description
|
|
|
•
|
UpdateData sets the value that the element stored in the row (indicated by the row cursor) and the column (indicated by index) will be changed to on a call to UpdateRow. The value the element will be changed to is data.
|
|
•
|
To update a row, set the new values by by calling UpdateData and then submit these updates by calling UpdateRow. Changing the current row 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. Particular JDBC Drivers and databases may allow a wider range of updatable tables and thus Result modules.
|
|
|
|
Examples
|
|
Create a Result to be updated.
|
>
|
![driver := Database[LoadDriver]()](/support/helpjp/helpview.aspx?si=7921/file05715/math110.png)
|
|
| (1) |
Get the current values.
|
>
|
|
|
| (2) |
|
>
|
|
|
| (3) |
|
>
|
|
|
| (4) |
Set the update values.
The new values are not sent to the database yet.
|
>
|
|
|
| (5) |
|
>
|
|
|
| (6) |
|
>
|
|
|
| (7) |
Update the row.
|
>
|
|
Check the values.
|
>
|
|
|
| (8) |
|
>
|
|
|
| (9) |
|
>
|
|
|
| (10) |
|
|
Download Help Document
Was this information helpful?
