SQL. InitializeSQLite (Dir As String, FileName As String, CreateIfNecessary As Boolean)Opens the SQLite database file. A new database will be created if it does not exist and CreateIfNecessary is true.Note that you should add the following attribute to the main module: #AdditionalJar: sqlite-jdbc-3.7.2 Example: Dim SQL1 As SQL SQL1.InitializeSQLite(File.DirApp, "MyDb.db", True) B4A Tutorial [B4X][B4XPages] SQL + xCLV Example - Erel    Jun 23, 2021   (19 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   (14 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 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... 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... B4J Tutorial SQL Tutorial - Erel    Dec 8, 2013   (5 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 Code Snippet Clone SQLite Database to SQLite Memory Database - tchart    Mar 28, 2023   (10 reactions) . NOTE this can be used to clone to a regular SQLite DB as well. Dim src_db As SQL Dim dest_db As SQL src_db.InitializeSQLite(File.DirApp,"report.sqlite",False) dest_db.InitializeSQLite("", ":memory:",True) DBUtils.CopySQLiteDB(src_db,dest_db) You can then use the dest_db SQL object as per normal.... B4J Question Class not found: org.sqlite.JDBC - Erel (first post)    Feb 10, 2019 See SQL.InitializeSQLite documentation: https://www.b4x.com/android/forum/pages/results/?query=sql.initializesqlite&product=b4j... B4J Code Snippet [B4X] MiniORMUtils - SQL Query Builder - giannimaione (first post)    Oct 19, 2023
#AdditionalJar: sqlite-jdbc-3.7.2
#End Region
*
*
Sub Process_Globals
Dim SQL As SQL
End Sub
*
*
*
SQL.InitializeSQLite(File.DirApp, "demo.db", True) 'ALWAYS EMPTY (no table... B4J Question Sqlite DB in B4Xpages Error java.lang.RuntimeException: Class not found: ..... Are you missing an #AdditionalJar attribute setting? - klaus (first post)    Mar 15, 2021   (3 reactions) It must be: SQL1.InitializeSQLite(SQLDataBasePath, SQLDateBaseName, True)... Wish [Cross-Platform] SQL Library Suggestions - LWGShane    Jan 27, 2017 With the existence of RDC, I'm suggesting the following for the SQL library:
- Replace "InitializeSQLite" with "Initialize" and remove the MySQL functions. (So the libraries do the same thing across B4A, B4i, and B4J.)
- Rename all SQL libraries to B4XSQLite... Page: 1   2   3   4   5   6   7   |