I have a project that creates an encrypted SQLite database using a Xojo SQLiteDatabase object. I can open, read, write and close it OK. Now I want to open it using SQLDatabaseMBS’ ability to open SQLite databases. My problem is that the .Connect always fails.
First I set to the correct password for encryption:
tempSQLDatabaseMBS.Password = "my password"
Then I set:
tempSQLDatabaseMBS.DatabaseName = "sqlite:" + SQLiteFolderItem.ShellPath
Once I have done this the following line fails:
Is there something I’m missing? Do I need to place the password in the DataBaseName?
Separately, I am not sure now to specify the SQLite pathname if it contains spaces. I have tried using NativePath and ShellPath without success, even if inside double-quotes.