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.

$\mathrm{driver}≔\mathrm{Database}\left[\mathrm{LoadDriver}\right]\left(\right)\:$

$\mathrm{conn}≔\mathrm{driver}:-\mathrm{OpenConnection}\left(\mathrm{url}\,\mathrm{name}\,\mathrm{pass}\right)\:$$\mathrm{result}≔\mathrm{conn}:-\mathrm{ExecuteQuery}\left(''SELECT\; *\; FROM\; animals''\right)$

$\mathrm{result}≔\mathbf{module}\left(\right)\mathbf{option}\mathrm{unload}\=\mathrm{Close}\;\mathbf{local}\mathrm{handle}\;\mathbf{export}\mathrm{Next}\,\mathrm{Previous}\,\mathrm{Last}\,\mathrm{First}\,\mathrm{GetRowNumber}\,\mathrm{GotoRow}\,\mathrm{GetRowCount}\,\mathrm{InsertRow}\,\mathrm{DeleteRow}\,\mathrm{UpdateRow}\,\mathrm{GetData}\,\mathrm{UpdateData}\,\mathrm{GetType}\,\mathrm{GetName}\,\mathrm{GetColumnCount}\,\mathrm{SetOptions}\,\mathrm{GetOptions}\,\mathrm{Close}\,\mathrm{ToMaple}\;\mathbf{end\; module}$

$$\begin{gathered} \mathbf{while}r:-\mathrm{Next}\left(\right)\mathbf{do} \\ r:-\mathrm{GetData}\left(''id''\right),r:-\mathrm{GetData}\left(''name''\right),r:-\mathrm{GetData}\left(''number''\right),r:-\mathrm{GetData}\left(''mass''\right) \\ \mathbf{end}\mathbf{do} \end{gathered}$$

$1,''fish'',100,0.0100000000000000002$

$2,''dog'',10,20.5000000000000000$

$3,''cat'',10,5.50000000000000000$

$4,''rat'',50,0.500000000000000000$

$5,''horse'',3,400.300000000000011$

$6,''snake'',1,7.75000000000000000$

$7,''lizard'',5,0.100000000000000004$

$8,''parrot'',20,2.$

$9,''pig'',4,10.$

$10,''hamster'',30,0.200000000000000012$

$c:-\mathrm{ExecuteQuery}\left(''SELECT\; id,\; name\; FROM\; animals\; WHERE\; mass\; >\; 5''\,'\mathrm{output}'='\mathrm{table}'\right)$

$\mathrm{table}\left(\left[\left(2\,''id''\right)=3\,\left(4\,''id''\right)=6\,\left(3\,''name''\right)=''horse''\,\left(1\,''id''\right)=2\,\left(5\,''id''\right)=8\,\left(4\,''name''\right)=''snake''\,\left(3\,''id''\right)=5\,\left(2\,''name''\right)=''cat''\,\left(1\,''name''\right)=''dog''\,\left(5\,''name''\right)=''pig''\right]\right)$

$c:-\mathrm{ExecuteQuery}\left(''SELECT\; name,\; mass\; FROM\; animals\; WHERE\; number\; BETWEEN\; 10\; and\; 50''\,'\mathrm{output}'='\mathrm{Array}'\right)$

$\left[\begin{array}{cc}''dog''& 20.5000000000000000\\ ''cat''& 5.50000000000000000\\ ''rat''& 0.500000000000000000\\ ''parrot''& 2.\\ ''hamster''& 0.200000000000000012\end{array}\right]$