Odbc Toolkit - connection.execute

: execute (conn, query)

Perform SQL query query, that does not return result

Inputs

db

Previously created database connection object

sqlquery

A valid non selecting SQL query string

Outputs

None

Examples

Create a database table and insert a row

 
 # create sql connection
 db = database("default", "", "");
 # create table and then insert a row
 execute(db, 'CREATE TABLE Test (Id INTEGER PRIMARY KEY AUTOINCREMENT, Name TEXT)');
 execute(db, 'INSERT INTO Test (Name) VALUES ("Line1")');
 
 

See also: database, fetch.