ExecuteQuery - Maple Help
For the best experience, we recommend viewing online help using Google Chrome or Microsoft Edge.

Online Help

Connection

  

ExecuteQuery

  

execute a Single SQL Query

 

Calling Sequence

Parameters

Description

Examples

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.

(1)

Show the results.

(2)

Perform a more complex SELECT and convert the output to a Maple table.

(3)

Perform another SELECT and convert the output to a Maple Array.

(4)

See Also

Database

Database[Connection]

Database[Connection][ExecuteUpdate]

Database[PreparedStatement]

Database[Result]

Database[Statement]

Database[usage]

 


Download Help Document