Android Question DBUtils 2.01 Example

[Bhrt60]

Silly question...

I'm jumping into DButils as I have a project where that needs SQLliteDB
where does DBUtils get the SLQDatabase from

its NOT listed in the Files !

I want create my own database with 3-4 tables and use that

 

[Myr0n]

please check this tread
https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/

 

[Peter Simpson]

You posted this question in the incorrect part of the forum.

You have to create the database yourself manually, I personally use free software like SQLite Expert Personal 5 and also DB browser for SQLite, but I also have SQLite Administrator, there are plenty for you to use that are free and will help you easily create your SQLite database for using in your Android app.

 

[Myr0n]

To create your sqlite db, you can do it manually or use a IDE software like http://sqlitebrowser.org/ that is user friendly.

 

[mcqueccu]

You can create your database separately and include in the assets folder with DB BROWSER
You can still use the DBUTILS to access this database

Or

Use DBUTILS to create the database when your app runs.

 

[Bhrt60]

You can create your database separately and include in the assets folder with DB BROWSER
You can still use the DBUTILS to access this database

Or

Use DBUTILS to create the database when your app runs.

I have created a SQLite DB and a simple app - works but very crudly coded
I was trying to see how DBUtils works & trying to understand it ..

I sort of guessed that the DB is being created in Code but can't see where John Smith

sorry for posting in the "wrong" place Peter
I serioulsy thought the right place was Android > Tutorial & Examples

 

[OliverA]

I sort of guessed that the DB is being created in Code but can't see where John Smith

You seemed to trail off here. What was the question?

 

[klaus]

You may have a look at the B4A User's Guide.
A chapter is dedicated to SQLite with examples.

 

[Bhrt60]

You seemed to trail off here. What was the question?

Original question was - where does the DB & Data come from ?

Can't see SQL FILE for the database in FILES

Can't see "John Smith" in the code if was being CREATED
Can't see anything to Create the Database - only Tables !

 

[OliverA]

Can't see SQL FILE for the database in FILES

Look under Objects Sorry, this applies to B4J, not B4A

Can't see "John Smith" in the code if was being CREATED

Look for the sub named FillStudentsTable (in starter.bas)

Can't see anything to Create the Database - only Tables !

Look for sql.Initialize (in starter.bas)

 

[Erel]

Moved to the questions forum.