sqlite3_executeΒΆ

sqlite3_execute executes an SQL command.

result = sqlite3_execute(db, ssSQL)

Return Value

result is an empty string or a string matrix. If an error occurs, an exception is created.

Parameters

db

db is a handle returned by sqlite3_open.

ssSQL

ssSQL is an SQL string (see example). The SQL string syntax is specified in the article SQLite (SQL).

Example

The following example creates an SQLite database table.

db = sqlite3_open("c:/addresses.db");
sqlite3_execute(db, "create table Addresses(FirstName varchar(100), LastName varchar(100), EMail varchar(100));");
sqlite3_execute(db, "insert into Addresses values('Peter', 'Mueller', 'peter.mueller@axz.de');");
sqlite3_close(db);

This example returns all address table records:

db = sqlite3_open("c:/addresses.db");
smAddresses = sqlite3_execute(db, "select * from Addresses;");
sqlite3_close(db);
print smAddresses + "|";

History

Version

Description

5.5.0

New.

id-507022