Maple für Professional
Maple für Akademiker
Maple für Studenten
Maple Personal Edition
Maple Player
Maple Player für iPad
MapleSim für Professional
MapleSim für Akademiker
Maple T.A. - Testen & beurteilen
Maple T.A. MAA Placement Test Suite
Möbius - Online-Courseware
Machine Design / Industrial Automation
Luft- und Raumfahrt
Fahrzeugtechnik
Robotics
Energiebranche
System Simulation and Analysis
Model development for HIL
Anlagenmodelle für den Regelungsentwurf
Robotics/Motion Control/Mechatronics
Other Application Areas
Mathematikausbildung
Technik
Allgemein- und berufsbildende Schulen
Testen und beurteilen
Studierende
Finanzmodelle
Betriebsforschung
Hochleistungsrechnen
Physik
Live-Webinare
Aufgezeichnete Webinare
Geplante Veranstaltungen
MaplePrimes
Maplesoft-Blog
Maplesoft-Mitgliedschaft
Maple Ambassador Program
MapleCloud
Technische Whitepapers
E-Mail Newsletters
Maple-Bücher
Math Matters
Anwendungs-Center
MapleSim Modell-Galerie
Anwenderberichte
Exploring Engineering Fundamentals
Lehrkonzepte mit Maple
Maplesoft Welcome-Center
Resource-Center für Lehrer
Help-Center für Studierende
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