execute an arbitrary SQL string - Maple Help

Online Help

All Products    Maple    MapleSim


Home : Support : Online Help : Connectivity : Database Package : Statement : Database/Statement/Execute

Statement:-Execute - execute an arbitrary SQL string

Calling Sequence

statement:-Execute( sql )

Parameters

statement

-

Statement module

sql

-

string; one or more SQL statements to execute

Description

• 

Execute passes a string of SQL statements to the database to be executed.  The string can contain multiple statements and generate multiple return values.

• 

Execute returns the return value of the first statement.  The return values of subsequent statements are accessible through the NextResult command.

• 

If a statement is an update, then the return value is an integer representing the update count.  If a statement is a query, then the return value is a Result module representing the table of values.

• 

Not all Java Database Connectivity [JDBC] Drivers can handle multiple SQL statements in a single string.  In this case, the behavior of Execute with multiple statements is undefined.

• 

If only a single SQL statement is being executed, using ExecuteUpdate or ExecuteQuery may be more convenient.  However, if a large number of such statements are executed, Execute is more efficient.

Examples

driver:=Database[LoadDriver]:

conn:=driver:-OpenConnectionurl,name,pass:stat:=conn:-CreateStatement:

Execute some statements.

res:=stat:-ExecuteSELECT name FROM animals WHERE id = 1; SELECT name FROM animals WHERE id = 2; SELECT name FROM animals WHERE id = 3;:

Check the value.

res:-Next;res:-GetDataname

fish

(1)

Get the next result.

res:=stat:-NextResult:

Get the value.

res:-Next:res:-GetDataname

dog

(2)

Now the last result.

res:=stat:-NextResult:res:-Next:res:-GetDataname

cat

(3)

See Also

Database, Database[Connection][ExecuteQuery], Database[Connection][ExecuteUpdate], Database[Result], Database[Statement], Database[Statement][NextResult], Database[usage]


Download Help Document

Was this information helpful?



Please add your Comment (Optional)
E-mail Address (Optional)
What is ? This question helps us to combat spam