Statement - 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

Parameters

Description

Examples

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

driverDatabase[LoadDriver]:

conndriver:-OpenConnectionurl,name,pass:statconn:-CreateStatement:

Execute some statements.

resstat:-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.

resstat:-NextResult:

Get the value.

res:-Next:res:-GetDataname

dog

(2)

Now the last result.

resstat:-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