Database[SQLite] - Maple Programming Help

Online Help

All Products    Maple    MapleSim


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

Database[SQLite]

  

Execute

  

execute SQL statement

 

Calling Sequence

Parameters

Description

Examples

Compatibility

Calling Sequence

Opened( connection, sql )

Parameters

connection

-

database connection obtained using Open command

sql

-

SQL statement

Description

• 

The Execute command execute SQL statement using the provided database connection. On success NULL is returned.

• 

This command is intended to be used with SQL statements that do not return any output, such as CREATE TABLE or INSERT.

• 

Use semicolon (;) to separate statements.

Examples

withDatabaseSQLite

Attach,Bind,ClearBindings,Close,ColumnCount,ColumnNames,Execute,Fetch,FetchAll,FetchRow,Finalize,Open,Opened,Prepare,RESULT_BUSY,RESULT_DONE,RESULT_ROW,Reset,Step

(1)

Create in memory database

dbOpen:memory::

Create table test with on column val1

Executedb,CREATE TABLE test (val1)

Compatibility

• 

The Database[SQLite][Execute] command was introduced in Maple 18.

• 

For more information on Maple 18 changes, see Updates in Maple 18.