B4J Question Problem with sqlite access.

A

Andromeda

Member
Licensed User
Longtime User
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
 

Attachments

  • B4XPagesSQLiteLight2.zip
    33.4 KB · Views: 103
Sort by date Sort by votes
A

Andromeda

Member
Licensed User
Longtime User
not here, i just checked my own directory ..same bug,
then uncompress the zip file again in a new directory, same bug...
 
Upvote 0

josejad

Expert
Licensed User
Longtime User
Andromeda said:
But when i check the DB the column is there
Click to expand...
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

B4X: 
    '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
 
Upvote 1
You must log in or register to reply here.

Similar Threads

Bug? [EDIT: NO BUGS HERE] ExecQuerySingleResult (SQLite)
2
Replies
37
Views
3K
LucaMs
  • Article
Share My Creation [Project Template] [Web] API Server
4 5 6
Replies
110
Views
30K
aeric
  • Article
Share My Creation [B4J] MySQL API Server (Key + Token) and [B4X] User Login Apps
2 3
Replies
42
Views
19K
pixet
  • Locked
  • Question
B4J Question Problem/bug? using B4JBuilder 7.31
Replies
10
Views
2K
Erel
  • Article
B4J Library Modded jRDC2 w/SQLite support and more
2
Replies
20
Views
9K
OliverA
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…