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. |
See also
id-507022