B4J Question Problem with sqlite access.

[Andromeda]

Hello,

i want to access a sqlite DB. All looks fine. But after i add a new field, i cant access this field. it throws an ERROR that this field isnt there.

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such column: customer).

But when i check the DB the column is there.

To get to the bug, go to drawer on left top side, choose jobs.... -> bug

 

[josejad]

Working fine here

 

[Andromeda]

not here, i just checked my own directory ..same bug,
then uncompress the zip file again in a new directory, same bug...

 

[josejad]

But when i check the DB the column is there

What db are you checking? The one you have in your files tab or the one in xui.DefaultFolder? (log xui.DefaultFolder and check that one too).

Because if you have the old db in xui.DefaultFolder, the new one will be not copied

    'copy the default DB
    If File.Exists(xui.DefaultFolder, "jobs.db") = False Then
        File.Copy(File.DirAssets, "jobs.db", xui.DefaultFolder, "jobs.db")
    End If

 

[Andromeda]

Yes, thats it