### Connect to a SQLite Database

Quick Steps to connect to a SQLite Database
• Add to Project Attributes: #AdditionalJar: sqlite-jdbc-3.7.2
• Select the jSQL Library in the B4J IDE Library Manager
• Define global SQL var: Dim gSQL As SQL
• Init gSQL: gSQL.InitializeSQLite(File.DirApp, "yourdb.db", True)
• Define a resultset: Dim RS As ResultSet
• Execute select query: RS = gSQL.ExecuteQueery("SELECT FROM Table")
• Iterate the resultset:
Do While RS.NextRow
Log(RS.GetString("col1"))
Loop
RS.Close
Hint:
It is advised to use the DBUtils module with SQLite databases.

Changed: , Category: SQLite, File: T6C254M1818.htm, ID: 1818