Maple Professional
Maple Academic
Maple Student Edition
Maple Personal Edition
Maple Player
Maple Player for iPad
MapleSim Professional
MapleSim Academic
Maple T.A. - Testing & Assessment
Maple T.A. MAA Placement Test Suite
Möbius - Online Courseware
Machine Design / Industrial Automation
Aerospace
Vehicle Engineering
Robotics
Power Industries
System Simulation and Analysis
Model development for HIL
Plant Modeling for Control Design
Robotics/Motion Control/Mechatronics
Other Application Areas
Mathematics Education
Engineering Education
High Schools & Two-Year Colleges
Testing & Assessment
Students
Financial Modeling
Operations Research
High Performance Computing
Physics
Live Webinars
Recorded Webinars
Upcoming Events
MaplePrimes
Maplesoft Blog
Maplesoft Membership
Maple Ambassador Program
MapleCloud
Technical Whitepapers
E-Mail Newsletters
Maple Books
Math Matters
Application Center
MapleSim Model Gallery
User Case Studies
Exploring Engineering Fundamentals
Teaching Concepts with Maple
Maplesoft Welcome Center
Teacher Resource Center
Student Help Center
Result:-UpdateRow - send row updates to the database
Calling Sequence
result:-UpdateRow( )
Parameters
result
-
Result module
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.
Get the current values.
Set the update values.
The new values are not sent to the database yet.
Update the row.
Check the values.
See Also
Database, Database[Result], Database[Result][GotoRow], Database[Result][Last], Database[Result][Next], Database[Result][Previous], Database[Result][UpdateData], Database[usage]
Download Help Document