Result:-UpdateRow - send row updates to the database
|
Calling Sequence
|
|
result:-UpdateRow( )
|
|
Description
|
|
•
|
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.
|
|
|
Examples
|
|
Create a Result to be updated.
>
|
|
| (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) |
>
|
|
| (11) |
|
|
Download Help Document
Was this information helpful?