Android Question sqlite question

[DPaul]

Hi,

In my app, i have a databse with 2 tables.
I write to the 2 tables, and save the db.
I know that is OK, because (a) i get no errors and
(b) i use vba to read the db and convert the 2 tables into xml files that are sent elsewhere.

Problem: the sqlite.db is then read on a PC using vb.net, which worked fine 6 months ago.
Today i tested again, and vb.net cannot find the tables any more.
Dim dt As DataTable = SQLconnect.GetSchema("Tables") ... dt.rows.count = 0

Did anything change in the last few months on the VBA side to cause vb.net not to see
the tables any more, although they are present. (No name mismatch, no upper/under case problems..

Just asking,
Paul

 

[DonManfred]

The Sqlite DB is on your device.

If you want to read the db from VB you first need to copy the newest db from your device to your pc.

 

[DPaul]

The Sqlite DB is on your device.

If you want to read the db from VB you first need to copy the newest db from your device to your pc.

Of course ! It is on my PC.
Remember, this worked 6 monthes ago, now vb.net sees no tables any more. B4a does
Paul

 

[DonManfred]

Can you upload the DB-File?

 

[DPaul]

One step further.
I installed an sqlite administrator on the PC side, and it confirms that the 2
tables are present (with fields and records) in the .db created by b4a.
So something must have changed on the vb side.
I should write to Bill Gates for that, this is not the right forum i suppose

Paul