SQL table

Rusty

Well-Known Member
Licensed User
Longtime User
1. Where does the simulator keep the built SQLlite tables? In memory/on disk...
2. Is there a way to copy an existing SQL database/tables into this (see above) location so it doesn't have to be dynamically created each time as in the samples?:sign0085:
 
Sort by date Sort by votes

Erel

B4X founder
Staff member
Licensed User
Longtime User
You can connect to the emulator with adb command (it is part of the Android sdk).
You can call adb push to copy files to the emulator and adb pull to copy files from the emulator.

You can also add the database in the Files tab and then copy it from the assets folder to the sd card when your program starts.
See this post for example: http://www.b4x.com/forum/basic4andr...m-when-reading-sqlite-database.html#post40704
 
Upvote 0

tremara1

Active Member
Licensed User
Longtime User
copy existing db

I used this code to copy an existing db from the dirassets to the sd card (DirDefaultExternal) if it does not already exist.
It works in the emulator just make sure your emulator is set up with sd card support.
B4X: 
If File.Exists(File.DirDefaultExternal,"meds.db") = False Then
      File.Copy(File.DirAssets,"meds.db",File.DirDefaultExternal,"meds.db")
   End If
   If SQL1.IsInitialized = False Then
        SQL1.Initialize(File.DirDefaultExternal, "meds.db", False)
   End If
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question Access to field type in SqlLite database
Replies
8
Views
3K
Paolo Pini
  • Question
Android Question How to manage null values in SqlLite GetString?
Replies
6
Views
2K
Mahares
M
  • Question
Android Question Clear data in SQLLite table [Solved]
Replies
4
Views
3K
Roger Daley
  • Question
Android Question SQL not finding "Table" SOLVED
Replies
7
Views
2K
Jmu5667
  • Question
Android Question Sqllite & Mysql update local tables
Replies
4
Views
2K
ocalle
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…