-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
Android Question How to "dump" a database to a text file?
- Thread starter vecino
- Start date
- Similar Threads Similar Threads
This thread is related to this one:
https://www.b4x.com/android/forum/threads/problem-database-malformed-on-some-tables.130720/
https://www.b4x.com/android/forum/threads/problem-database-malformed-on-some-tables.130720/
Upvote
0
I just have to ask, have you tried this:
B4X:
globales.DBconex.ExecNonQuery(".debug " & xui.DefaultFolder & "kk3.db")Just a final test from me to make sure that the destination path isn't the problem. Also try with .backup, obviously.
(Perhaps you need to add a slash in there, I forget if DefaultFolder has an ending slash.)
Upvote
0
Exactly the same, it doesn't know the dot ".", and if I remove the dot then it doesn't know "dump", "backup", etc.
By the way, "globales.cDBruta" is assigned the value of "xui.DefaultFolder".
It seems that the "Sql" library is very limited and does not have these commands implemented.
I think I'm going to leave it, export tables in text mode and I'm going to end this topic, I've already spent too much time on it, and it seems that we can't do more.
Thank you very much for your advice and time spent, friends.
?
By the way, "globales.cDBruta" is assigned the value of "xui.DefaultFolder".
It seems that the "Sql" library is very limited and does not have these commands implemented.
I think I'm going to leave it, export tables in text mode and I'm going to end this topic, I've already spent too much time on it, and it seems that we can't do more.
Thank you very much for your advice and time spent, friends.
?
Upvote
0
If we assume that's how one needs to do it, perhaps you could make a small class or b4xlib and upload? I'm sure there are others who would like to dump the database from within the app.
Upvote
0
Sometimes i am too lazy to overthinking, what i have done is create temporary database file (or you shipped empty temporary database file within your APK) contain tables you want to copy/hold data, and when you want to use those temporary database file just use ATTACH DATABASE to read/write the data, this is the fastest method i think.
Please note that the database i am talking about are SQLite for both source and destination database
Please note that the database i am talking about are SQLite for both source and destination database
Last edited:
Upvote
0
Yes that what i mean, by attaching another (temporary) database to current database with ATTACH DATABASE you can make copy data from one table (source) to another table (destination), you can copy all data or by selected criteria. When done you can DETACH the (temporary) database.
*Don't forget to place the temporary db location same as primary database, or you have to provide full-path if the database has different location
Last edited:
Upvote
0
Take a look to:
How to attach 2 databases and...
How would I write a query to attach (or join) 2 databases (main1 and temp1) and then insert the records from temp1.table1 into main1.table1. It is easy when in the same database - "INSERT INTO table1 SELECT * FROM table2" - (structure same of course). I hope it is as easy as example above...
Upvote
0
Similar Threads
- Question
- Question
Android Question
[Solved] B4XTable - How to load data from SQLite?