N Nitin Joshi Active Member Licensed User Longtime User Oct 31, 2018 #1 Is it possible to create database in B4A? Basically, I want to store some values and next time when app is opened I would like to access.
Is it possible to create database in B4A? Basically, I want to store some values and next time when app is opened I would like to access.
eps Expert Licensed User Longtime User Oct 31, 2018 #2 Yes, when you say values, what do you mean? A handful or lots? Related Data or just some values? You can store information in files and re-read those or you can have a full blown database, sqlite for instance.. Loads of example on here and some tutorials. e.g. https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content I've been using a sqlite database with B4A for a number of years now - I use the Firefox extension to create the database - and Excel to create a lot of the data (export from Excel as CSV and then import the CSV in to Firefox using the sqlite extension). Upvote 0
Yes, when you say values, what do you mean? A handful or lots? Related Data or just some values? You can store information in files and re-read those or you can have a full blown database, sqlite for instance.. Loads of example on here and some tutorials. e.g. https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content I've been using a sqlite database with B4A for a number of years now - I use the Firefox extension to create the database - and Excel to create a lot of the data (export from Excel as CSV and then import the CSV in to Firefox using the sqlite extension).
eps Expert Licensed User Longtime User Oct 31, 2018 #3 There's this https://www.b4x.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/ and this https://www.b4x.com/android/forum/threads/sqlitelight-four-simple-sqlite-projects.35419/ fill your boots! Upvote 0
There's this https://www.b4x.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/ and this https://www.b4x.com/android/forum/threads/sqlitelight-four-simple-sqlite-projects.35419/ fill your boots!
eps Expert Licensed User Longtime User Oct 31, 2018 #5 Or this... https://www.b4x.com/android/forum/threads/text-files.6690/ Upvote 0
mcqueccu Expert Licensed User Longtime User Oct 31, 2018 #6 A simple search for Database will give you all the results you need https://www.b4x.com/android/forum/pages/results/?query=database Upvote 0
A simple search for Database will give you all the results you need https://www.b4x.com/android/forum/pages/results/?query=database
MarkusR Well-Known Member Licensed User Longtime User Oct 31, 2018 #7 usual u need a database if you will query/search/filter for data. alternate u can use a type put it into a list and save/load it via "File..." Upvote 0
usual u need a database if you will query/search/filter for data. alternate u can use a type put it into a list and save/load it via "File..."
jimmyF Active Member Licensed User Longtime User Oct 31, 2018 #8 Just to store some values and retrieve them on restart of the app. https://www.b4x.com/android/forum/threads/b4x-keyvaluestore-2-simple-powerful-local-datastore.63633/ Upvote 0
Just to store some values and retrieve them on restart of the app. https://www.b4x.com/android/forum/threads/b4x-keyvaluestore-2-simple-powerful-local-datastore.63633/
