Android Question problem about access SQL database

K

kcwenfrank

New Member
I am trying to do some exercise about sql database with B4A, However, I am stuck here for a while,
I tried to build a sample sql-database in advance and then write some simple code in B4A.
The code is very simple as below
B4X: 
        SQL1.Initialize(File.DirInternal,"example.db", True)

    SQL1_Index=SQL1.ExecQuery("SELECT * from sql_exercise")
the problem is every time the code crash after running ExecQuery.
Can some one give me a hint for this ?
 

Attachments

  • sql_exercise.zip
    8.2 KB · Views: 306
Sort by date Sort by votes
R

ronell

Well-Known Member
Licensed User
Longtime User
include the error logs in your post .. we cant help without it

edit: change your code
B4X: 
File.DirInternal
to
B4X: 
File.DirAssets
 
Last edited:
Upvote 0

klaus

Expert
Licensed User
Longtime User
The files in the File folder of your project are in File.DirAssets and not in the File.DirInternal folder.
These are two different folders.
Databases cannot be accessed in File.DirAssets, they must be copied somewhere else, for example to File.DirInternal.
Attached a modified project.
I suggest you to have a look at the B4X Booklets and more specific the SQLite chapter in the B4A User's Guide.
You may also have a look at the SQLiteLight examples, which are shipped with the User's Guide.
 

Attachments

  • sql_exercise1.zip
    8.4 KB · Views: 337
Upvote 0
R

ronell

Well-Known Member
Licensed User
Longtime User
klaus said:
Databases cannot be accessed in File.DirAssets, they must be copied somewhere else, for example to File.DirInternal.
Click to expand...
forgot about that lol , it should be like this
B4X: 
If File.Exists(File.DirInternal,"example.db") = False Then
        File.Copy(File.DirAssets,"example.db",File.DirInternal,"example.db")
    End If
 
Upvote 0
K

kcwenfrank

New Member
ronell, thank you for the reply.
I am not sure if I misunderstanding or not. The original code will give me the error msg as below.
android.database.sqlite.SQLiteException: no such table: sql_exercise (code 1): , while compiling: SELECT * from sql_exercise
I think the SQL command should be correct as I tried in SQLite Expert already.
I also modified the code as your suggestion and got the error msg as below.
android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open database
I think the initialize should be no problem , just don't know if i miss anything or not.
 
Upvote 0
K

kcwenfrank

New Member
klaus, thank you for the replay. Sorry, I just replied ronell's post.
Anyway I just saw your replied and tried the code already. It works great and your replied help me as well.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
Android Example Syncing local databases using PHP to access a database on a hosted server
Replies
1
Views
7K
thetrueman
T
  • Article
Share My Creation [B4J] [MySQL] [API] Server (Key + Token) and [B4X] User Login Apps
2 3
Replies
45
Views
44K
aeric
  • Locked
  • Article
B4A Library JdbcSQL - Directly connect to remote databases
2
Replies
23
Views
75K
Erel
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
139
Views
190K
Erel
  • Locked
  • Article
Android Tutorial Remote Database Connector (RDC) - Connect to any remote DB
20 21 22
Replies
423
Views
388K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…