dhernandez Active Member Licensed User Longtime User Mar 6, 2014 #1 Hi all, I have a question for you. How do you to copy data from a remote database (MySQL) and insert it into my device in SQLite? My SQLite has the same fields MySQL Thanks in advance-...
Hi all, I have a question for you. How do you to copy data from a remote database (MySQL) and insert it into my device in SQLite? My SQLite has the same fields MySQL Thanks in advance-...
giga Well-Known Member Licensed User Longtime User Mar 6, 2014 #2 I would first download the data as a CSV(Comma Separated Value) file. You could use this as a backup, but also as possibly to read from and insert into SQLite. Upvote 0
I would first download the data as a CSV(Comma Separated Value) file. You could use this as a backup, but also as possibly to read from and insert into SQLite.
dhernandez Active Member Licensed User Longtime User Mar 6, 2014 #3 There will be no way to create one in config.properties select_data line = "SQL statement" to look for me and me the data inserted from Remote to Local? Just as is done by inserting SQLite to MySQL ... using Remote Database Connector Upvote 0
There will be no way to create one in config.properties select_data line = "SQL statement" to look for me and me the data inserted from Remote to Local? Just as is done by inserting SQLite to MySQL ... using Remote Database Connector
Erel B4X founder Staff member Licensed User Longtime User Mar 7, 2014 #4 Create a query that downloads the complete table and then add the data to the local database. Make sure to create a single transaction when adding the data. Upvote 0
Create a query that downloads the complete table and then add the data to the local database. Make sure to create a single transaction when adding the data.