Search Results

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...

:\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...

.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 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...

SQL.InitializeSQLite(File.DirApp, "SBA_Project.db", True)...
link: ) sql.InitializeSQLite(File.DirApp, "db.db", True) Log(sql.ExecQuerySingleResult...

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...

I 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...

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...

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...

Hello as for B4A the initialize statement includes the possibility to create an empty database if the named database file is not found. sql.initializeSQLite(file.dirApp,Filename,true) I did not find the same in the statement to be used for B4J. SQL.Initialize("org.sqlite.JDBC","jdbc...
link: the named database file is not found. sql.initializeSQLite(file.dirApp,Filename,true) I did not find...
link: . As was shown in the code posted by @Swissmade, B4J SQL (jSQL library) has an InitializeSQLite...