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:-ExecuteQuery - execute a Single SQL Query
Calling Sequence
connection:-ExecuteQuery( stat, opts )
Parameters
connection
-
Connection module
stat
string; the SQL query to execute
opts
(optional) equation of the form output=name
Description
ExecuteQuery executes an SQL query over connection. The SQL string stat must contain only a single SQL statement that performs a query and returns a single table. Passing any other statement to ExecuteQuery is an error.
By default, the value returned by ExecuteQuery is a Result module. However, you can specify a different format by specifying the output optional argument.
output = result, table, Array, or browser
Specify the type for the return value of ExecuteQuery.
- result returns a Result module.
- table formats the SQL table as a Maple table.
- Array formats the SQL table as an Array.
- browser opens a Maplet application to visualize the SQL table.
For more information, see ToMaple.
Examples
Query some data from the database.
Show the results.
Perform a more complex SELECT and convert the output to a Maple table.
Perform another SELECT and convert the output to a Maple Array.
See Also
Database, Database[Connection], Database[Connection][ExecuteUpdate], Database[PreparedStatement], Database[Result], Database[Statement], Database[usage]
Download Help Document
