B Bhrt60 Member Licensed User Mar 14, 2018 #1 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 Last edited: Mar 14, 2018
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 Active Member Licensed User Longtime User Mar 14, 2018 #2 please check this tread https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/ Upvote 0
Peter Simpson Expert Licensed User Longtime User Mar 14, 2018 #3 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. Last edited: Mar 14, 2018 Upvote 0
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 Active Member Licensed User Longtime User Mar 14, 2018 #4 To create your sqlite db, you can do it manually or use a IDE software like http://sqlitebrowser.org/ that is user friendly. Upvote 0
To create your sqlite db, you can do it manually or use a IDE software like http://sqlitebrowser.org/ that is user friendly.
mcqueccu Expert Licensed User Longtime User Mar 14, 2018 #5 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. Upvote 0
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.
B Bhrt60 Member Licensed User Mar 14, 2018 #6 mcqueccu said: 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. Click to expand... 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 Upvote 0
mcqueccu said: 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. Click to expand... 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 Expert Licensed User Longtime User Mar 14, 2018 #7 Bhrt60 said: I sort of guessed that the DB is being created in Code but can't see where John Smith Click to expand... You seemed to trail off here. What was the question? Upvote 0
Bhrt60 said: I sort of guessed that the DB is being created in Code but can't see where John Smith Click to expand... You seemed to trail off here. What was the question?
klaus Expert Licensed User Longtime User Mar 14, 2018 #8 You may have a look at the B4A User's Guide. A chapter is dedicated to SQLite with examples. Upvote 0
B Bhrt60 Member Licensed User Mar 14, 2018 #9 OliverA said: You seemed to trail off here. What was the question? Click to expand... 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 ! Upvote 0
OliverA said: You seemed to trail off here. What was the question? Click to expand... 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 Expert Licensed User Longtime User Mar 14, 2018 #10 Bhrt60 said: Can't see SQL FILE for the database in FILES Click to expand... Look under Objects Sorry, this applies to B4J, not B4A Bhrt60 said: Can't see "John Smith" in the code if was being CREATED Click to expand... Look for the sub named FillStudentsTable (in starter.bas) Bhrt60 said: Can't see anything to Create the Database - only Tables ! Click to expand... Look for sql.Initialize (in starter.bas) Last edited: Mar 15, 2018 Upvote 0
Bhrt60 said: Can't see SQL FILE for the database in FILES Click to expand... Look under Objects Sorry, this applies to B4J, not B4A Bhrt60 said: Can't see "John Smith" in the code if was being CREATED Click to expand... Look for the sub named FillStudentsTable (in starter.bas) Bhrt60 said: Can't see anything to Create the Database - only Tables ! Click to expand... Look for sql.Initialize (in starter.bas)
Erel B4X founder Staff member Licensed User Longtime User Mar 15, 2018 #11 Moved to the questions forum. Upvote 0
