.. highlightlang:: us

.. _sqlite3_execute:

sqlite3_execute
===============

.. index:: sqlite3_execute

.. us.tag  sqlite3_execute NOTREADYENGLISH New550 sqlite3

:ref:`sqlite3_execute` executes an SQL command.

.. function::  result = sqlite3_execute(db, ssSQL)

.. us.return

**Return Value**

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

.. us.params

**Parameters**

.. uparam:: db

   *db* is a handle returned by :ref:`sqlite3_open`.

.. uparam:: ssSQL

   *ssSQL* is an SQL string (see example). The SQL string syntax is
   specified in the article :ref:`sqlite-(sql)`.

.. us.example

**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 + "|";

.. us.history

**History**

.. list-table::
   :header-rows: 1

   * - Version
     - Description
   * - 5.5.0
     - New.

.. seealso::
   :ref:`overview-sqlite`,
   :ref:`sqlite3_open`,
   :ref:`GetExceptionInfo`

:sub:`id-507022`