|
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.
|
|
|
|
Examples
|
|
Query some data from the database.
|
>
|
![driver := Database[LoadDriver]()](/support/helpjp/helpview.aspx?si=7888/file05676/math124.png)
|
|
>
|
 
|
|
| (1) |
Show the results.
|
>
|
|
|
| (2) |
Perform a more complex SELECT and convert the output to a Maple table.
|
>
|
|
|
![table([(2, "id") = 3, (4, "id") = 6, (3, "name") = "horse", (1, "id") = 2, (5, "id") = 8, (4, "name") = "snake", (3, "id") = 5, (2, "name") = "cat", (1, "name") = "dog", (5, "name") = "pig"])](/support/helpjp/helpview.aspx?si=7888/file05676/math177.png)
| (3) |
Perform another SELECT and convert the output to a Maple Array.
|
>
|
|
|
![matrix([["dog", 20.5000000000000000], ["cat", 5.50000000000000000], ["rat", .500000000000000000], ["parrot", 2.], ["hamster", .200000000000000012]])](/support/helpjp/helpview.aspx?si=7888/file05676/math186.png)
| (4) |
|
|
Download Help Document
Was this information helpful?
