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:-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.
commit = true or false
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.
See Also
Database, Database[Connection], Database[PreparedStatement], Database[Result], Database[Statement], Database[usage]
Download Help Document