.. index:: single: SQLite; Introduction ================ SQLite Functions ================ In this chapter we will learn about using the SQLite database in the Ring programming language. Before using the next function load the sqlitelib.ring library .. code-block:: ring load "sqlitelib.ring" # Use SQLite functions .. index:: pair: SQLite; sqlite_init() sqlite_init() function ====================== Syntax: .. code-block:: ring sqlite_init() ---> SQLite Object .. index:: pair: SQLite; sqlite_open() sqlite_open() function ====================== Syntax: .. code-block:: ring sqlite_open(SQLite Object,cFileName) .. index:: pair: SQLite; sqlite_execute() sqlite_execute() function ========================= Syntax: .. code-block:: ring sqlite_exexute(SQLite Object,cSQLStatement) .. index:: pair: SQLite; sqlite_close() sqlite_close() function ======================= Syntax: .. code-block:: ring sqlite_close(SQLite Object) Example ======= The next code create a SQLite database, add new records then display the data. .. code-block:: ring oSQLite = sqlite_init() sqlite_open(oSQLite,"mytest.db") sql = "CREATE TABLE COMPANY(" + "ID INT PRIMARY KEY NOT NULL," + "NAME TEXT NOT NULL," + "AGE INT NOT NULL," + "ADDRESS CHAR(50)," + "SALARY REAL );" sqlite_execute(oSQLite,sql) sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " + "VALUES (1, 'Mahmoud', 29, 'Jeddah', 20000.00 ); " + "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " + "VALUES (2, 'Ahmed', 27, 'Jeddah', 15000.00 ); " + "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" + "VALUES (3, 'Mohammed', 31, 'Egypt', 20000.00 );" + "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY)" + "VALUES (4, 'Ibrahim', 24, 'Egypt ', 65000.00 );" sqlite_execute(oSQLite,sql) aResult = sqlite_execute(oSQLite,"select * from COMPANY") for x in aResult for t in x see t[2] + nl next next see copy("*",50) + nl for x in aResult see x["name"] + nl next sqlite_close(oSQLite) Output: .. code-block:: ring 1 Mahmoud 29 Jeddah 20000.0 2 Ahmed 27 Jeddah 15000.0 3 Mohammed 31 Egypt 20000.0 4 Ibrahim 24 Egypt 65000.0 ************************************************** Mahmoud Ahmed Mohammed Ibrahim