B4J Library SQLite Enable Loading of Extensions - tchart Oct 1, 2025 (9 reactions) library for your OS (eg DLL for Windows and SO for Linux)
How to use;
Dim SQL As SQL
SQL.InitializeSQLite(File.DirApp,"Test.sqlite",True)
Log(SQL.IsInitialized)
Dim e... SQLite.
EnableLoading(SQL) - enable loading of SQLite extensions
DisableLoading(SQL) - disable...
link: Hey @tchart
SQL.InitializeSQLite(File.DirApp,"Test.sqlite?enable_load_extension=true"...
link: : you can actually use InitializeSQLite as well.
SQL.InitializeSQLite(File.DirApp,"Test.sqlite...
B4J Question Integrated Packager not working? - Guenter Becker (first post) Jun 16, 2026
Post the line with SQL.InitializeSQLite
xui.SetDataFolder(File.DirApp)
sql.InitializeSQLite(xui.DefaultFolder,"Licence.db",False)...
link: Post the line with SQL.InitializeSQLite...
B4J Tutorial Backup SQLite DB with VACUUM INTO - Chris2 Jan 8, 2023 (9 reactions):\DBBackup\myDB-backup.db" 'backupPath must include the filename
Dim sql As SQL
sql.InitializeSQLite(filePath, fileName, False)
sql.ExecNonQuery2("VACUUM INTO ?", Array... shrunk to its minimum size.
Usage is pretty simple with the SQL library:
Dim filePath As String...
link: .db")
Catch
Log(LastException)
End Try
MySQL.InitializeSQLite...
B4A Tutorial [B4X][B4XPages] SQL + xCLV Example - Erel Jun 23, 2021 (20 reactions).DefaultFolder, dbname)
#if B4J
'B4J SQL object can access many types of databases (same as B4A JdbcSQL).
sql.InitializeSQLite(xui.DefaultFolder, dbname, False)
#else
sql.Initialize(xui.DefaultFolder, dbname, False)
#End If
Dim rs As ResultSet = sql.ExecQuery2($"SELECT...)
B4XPages.SetTitle(Me, "SQL + xCLV Example")
xui.SetDataFolder("sql example...
B4J Tutorial [WebApp] Concurrent access to SQLite databases - Erel Nov 21, 2021 (15 reactions). B4J SQL library (when initialized with InitializeSQLite) will serialize writers access.
- When... such as MySQL and others.
However they can still be perfect for small / medium solutions, especially if... databases. You need to follow these instructions:
- Use a single SQL object that is shared by all... set the journal mode to wal:
sql.ExecQuerySingleResult("PRAGMA journal_mode = wal"....b4x.com/b4j/help/jsql.html#sql_begintransaction...
B4J Question Application runs on OK on Debug but no SQLite Queries on Standalone - Setlodi (first post) Apr 20, 2025SQL.InitializeSQLite(File.DirApp, "SBA_Project.db", True)...
link: )
sql.InitializeSQLite(File.DirApp, "db.db", True)
Log(sql.ExecQuerySingleResult...
B4J Question How do you use SQLite in B4J pages? - Erel (first post) Feb 9, 2025 (2 reactions)The same code will work with B4J. You just need to call SQL.InitializeSQLite and add this line to main module:
#AdditionalJar: sqlite-jdbc-3.7.2
...
link:
The same code will work with B4J. You just need to call SQL.InitializeSQLite and add this line to...
link: ?
sql.InitializeSQLite(File.DirData("sql"),"patient.db",True)
WebView1...
B4J Tutorial SQL Tutorial - Erel Dec 8, 2013 (6 reactions)B4J jSQL library is similar to Basic4android SQL library.
This tutorial will cover the differences.../android/forum/threads/sql-tutorial.6736/#content
jSQL library is not tied to any specific SQL engine. jSQL wraps Java JDBC mechanism and allows you to access any type of SQL database. Including remote... to add the jar to the package.
For example to connect to a MySQL database:
#Region Project... sql1 As SQL
End Sub
Sub AppStart (Form1 As Form, Args() As String)
MainForm = Form1
MainForm...
B4J Question Standalone application with SQLite - danchovasilev Dec 22, 2024I made a small application that works with a SQLite database, but when I compile it, it gives me an error - it cannot find the path to the database using SQL.InitializeSQLite(File.DirApp, "dk6.db", True)
please help...
B4A Library [B4X] [XUI] AS Scheduler 📅 - MonthView, DayView (Week), AgendaView and CalendarView [Payware] - MarcoRome (first post) Dec 14, 2023
The SchedulerInternShared Modul is calling this:
#If B4J
SQL.InitializeSQLite(File.DirApp...
SQL.InitializeSQLite(File.DirApp,"scheduler.db",True)
Else
SQL.InitializeSQLite(File.DirTemp,"scheduler.db",True)
End If
#Else
SQL...
link: is calling this:
#If B4J
SQL.InitializeSQLite(File.DirApp,"scheduler.db",True)
#Else...
link: = "windows" Then
SQL.InitializeSQLite(File.DirApp,"scheduler.db",True...
Page: 1
2
3
4
5
6
7
