Connection
ExecuteQuery
execute a Single SQL Query
Calling Sequence
Parameters
Description
Examples
connection:-ExecuteQuery( stat, opts )
connection
-
Connection module
stat
string; the SQL query to execute
opts
(optional) equation of the form output=name
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.
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