Connecting to a SQLite 3 Database

[devlei]

I have just started with B4A and am struggling connecting to my SQLite 3.x database. I also notice that when I use SQLite Database Browser to try open any of the databases created by B4A (“1.db” from the DBUtils sample) it gives an error and says “File is not a SQLite 3 database.”

I am obviously missing something here, can you help?

 

[Merlot2309]

Hello,

Which tool do you use to maintain the database?

I always rename the extension of the file from .sqlite to .sql

Helen.

 

[devlei]

On the desktop, SQLite Database Browser.
On the device, aSQLite Manager.

 

[Merlot2309]

Hello,

Is the encoding set to UTF-8?
When you open the database in Notepad, does it start with


Helen.

 

[devlei]

Thanks for your reply.

Opening it in Notepad gives:
How do I set encoding to UTF-8?

 

[Merlot2309]

Hi,

I never used DBUtils (yet).
But did you try renaming the extension of the db file to .sql?

You can check the database records with:

Mozilla Firefox has a great plugin: SQLite Manager (do a Google search).
In this SQLite Manager you connect your database and will see immediately if the records are looking ok.
In the "db settings" tab there is a field: Encoding.
Standard this is set to UTF-8.

Helen.

 

[tcgoh]

Hi, sorry to steal this thread

I have a .sl3 database from Basic4ppc, could this be used in basic4andriod?

Thanks

 

[Merlot2309]

Hi,

Yes, the same databases can be used in Android, Windows and WM.

Helen.