sqlite_execute

sqlite_execute executes an SQL command.

result = sqlite_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 sqlite_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 = sqlite_open("c:/addresses.db");
sqlite_execute(db, "create table Addresses(FirstName varchar(100), LastName varchar(100), EMail varchar(100));");
sqlite_execute(db, "insert into Addresses values('Peter', 'Mueller', 'peter.mueller@axz.de');");
sqlite_close(db);

This example returns all address table records:

db = sqlite_open("c:/addresses.db");
smAddresses = sqlite_execute(db, "select * from Addresses;");
sqlite_close(db);
print smAddresses + "|";

See also

Overview sqlite, sqlite_open, GetExceptionInfo

_id-27082