Search Results

For offline Create a new table in the database called user, then from b4j Dim Sql1 As SQL Sql1.InitializeSQLite(File.DirApp, "mydb.db" , False) 'insert to DB Main.Sql1.BeginTransaction Try /// my db > user > id,name,pass,date Main.Sql1.ExecNonQuery2("INSERT

Thanks everyone! I found the jSQL library easy to use, creating a database without a file doing this: sql1.InitializeSQLite("", ":memory:", True) sql1.ExecNonQuery("CREATE TABLE table1 (col1 TEXT, col2 TEXT)") Executing queries after loading the said data into it works like a charm.
link: sqLite queries can have parameters which can also be tested. A typical subroutine to create a DB and create a table within it are shown below: '==
link: SetDBVersion(SQL, NewVer) 'set new version = NewVer End If '-------------------------------------------------------------------

This is a prototype I wrote a while back that takes a source SQLite database and clones it to another SQLite database - in this case an in memory SQLite database. The code is prety straight forward, initialize the source (from) and destination (to) SQLite databases and call the CopySQLiteDB sub.

That's why the below 'Try' block with the SQL operations is there, ' and why it doesn't just open the database. A successful File.Delete is inconclusive. File.Delete(dir, fileName) Catch Return True End Try End If Try Dim sql1 As S

From Erel's B4xTable.b4xlib: #if B4J sql1.InitializeSQLite("", ":memory:", True) #Else If B4A OR B4I sql1.Initialize("", ":memory:", True) #End If Try whichever flavour you need.
link: @AKJammer Sorry, I hadn't read your post carefully enough. I didn't notice that you want to create the DB only internally without saving it outsides t
link: Hey Klaus, I looked there but it doesn't talk about initializing in Memory, only has a standard file database. B4J Add the line below in Main mod

Sqlite_Per_Vacuum.InitializeSQLite(filePath, fileName, False) Sqlite_Per_Vacuum.InitializeSQLite(filePath, fileName, True) these lines were to show what needed changing from false to true . I should have bolded the "true" as to avoid confusion. My code in post #4 I think it was is working code fro
link: Less of a tutorial, more to point out another option which doesn't seem to have a mention anywhere on here yet.... I was searching for options to cre
link: try this also when you first initialize the db MySQL.ExecQuerySingleResult("PRAGMA journal_mode = wal") so your code will look like this ? Dim fileP
link: I struggled to get this to work for a couple of days, here is the solution.... have one sql lite db for the project Globals Public MySql as SQL then

Don't use InitializeSQLite. Use Initialize or Initialize2. Something like sql.Initialize("com.sqlite.JdbcUrl","jdbc:sqlite:test.db") That should open an unencrypted test.db SQLite database file that is located in the same directory as the the program file (.jar) or, while developing, in the Object
link: Something that you should be aware of: if you don't initialize it with InitializeSQLite then the library will not prevent multiple non-query commands
link: 1) If in the jSQL library (I'm looking at the source here: https://github..java) sqliteLock where public, we could also use JavaObject to set it with
link: Thank you for answering, but initializing jSQL for sqlite, does not allow you to pass any JDBC URL. Maybe needs a new wrapper for jSQL?

MainForm.Show sql1.InitializeSQLite("", ":memory:", True) sql1.ExecNonQuery("CREATE TABLE DATA (X INTEGER)") sql1.ExecNonQuery("INSERT INTO DATA VALUES(1)") Dim rs As ResultSet = sql1.ExecQuery("SELECT X FROM DATA") Dim M As Map M.Initialize If rs.NextRow Then Lo
link: Initialize("JobsTA") T.Editable = False LoadOpData(T, M) TM = ScheduleMod.MeasureText(T.Text, fx.Def

Exists(uc_DB_Path, dbName)==False Then Log("DB不存在??程式將自動建立 ") End If Log("uc_DB_Path= "&uc_DB_Path) SQLite.InitializeSQLite(uc_DB_Path, dbName, True) SQLite.ExecQuerySingleResult("PRAGMA

But SQLite initialization is Common.sql.InitializeSQLite(dbDirectory,Common.SqlDbName, False) How do you initialize a SQLite database into the pool? Hmmm. Just did some checking... You can't. https://www.b4x.-concurrent-access-to-sqlite-databases.39904/#content So I'll have to access the dat
link: Currently I'm opening a single connection to the database at program start and using that connection whenever I need one. If the program sits idle

Powered by ColBERT