Hi, I am sure this sort of problem has been dealt with many times before.
The code below is a selection of code I wrote way back in 2014 using XOJO V2.2 on a 32-bit Windows 7 machine. It worked perfectly (and still does) I now use Linux MINT 20.2 64bit and have the latest version of XOJO V1.2 2022. This code was copied over to Linux (along with the actual SQLite database (in the same directory as the app, as per the way I have it on the older Windows machine. My Linux copy now displays an error saying it cannot connect to the database. It compiles OK but displays the error at runtime. The code is identical to what is working on my older 32b Windows machine. I did make sure the architecture was changed to X86 64Bit. Please tell what Might be wrong
dim dbFile as FolderItem
dim db as SQLiteDatabase
dim stuff as RecordSet
dim sql as string
sql = “SELECT * FROM current”
// Establish a connection to the database.
db = New SQLiteDatabase
dbFile = SpecialFolder.CurrentWorkingDirectory.Child(“boxrecords.rsd”)
db.DatabaseFile = dbFile
// Make sure the connection to the database is successful.
if not db.Connect() then
MsgBox “Database connection failed for some stupid reason - like, maybe it’s not there anymore?”
end if
stuff = db.SQLSelect(sql)
DataList.DeleteAllRows() //Clear the list