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
Connection:-Commit - commit the current transaction
Calling Sequence
connection:-Commit( )
Parameters
connection
-
Connection module
Description
Commit closes the current transaction and applies all the changes to the database. After Commit has been called, a new transaction is in effect.
The current transaction can be canceled by calling Rollback.
Depending on the transaction isolation of the current Connection, updates made within a transaction may not be visible to other processes accessing the database until the changes are committed. For more information about transaction isolation, see SetOptions.
Examples
Execute an update.
At this point the new row is not in the database. If you were to exit Maple the row would be discarded. The update must be committed before it enters the database.
Now that Commit has been executed, the new row has been added to the database.
See Also
Database, Database[Connection], Database[Connection][CreatePreparedStatement], Database[Connection][CreateStatement], Database[Connection][ExecuteUpdate], Database[Connection][Rollback], Database[Statement], Database[usage]
Download Help Document