Problem with database

klaus

Expert

Licensed User

Longtime User

• Nov 12, 2012

• #2

You must be careful:
How many results are you expecting.
- SQL.ExecQuery returns a Cursor object with multiple results
- SQL.ExecQuerySingleResult returns a single value

I think in your case you should use SQL.ExecQuerySingleResult.

Best regards.

 

Upvote 0

F

fanfalveto

Active Member

Licensed User

Longtime User

• Nov 12, 2012

• #3

The problem is the same with ExecQuerySingleResult,this is the log:

android.database.sqlite.SQLiteException: no such table: table1: , while compiling: SELECT pregunta FROM table1 WHERE id=1

Click to expand...

but table1 exist,sure.I can see the table in the database with sqlite expert.
Thanks

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Nov 12, 2012

• #4

Couldn't you post your project as a zip file with the database so we could test it ?

Best regards.

 

Upvote 0

F

fanfalveto

Active Member

Licensed User

Longtime User

• Nov 12, 2012

• #5

thank you very much.
i put the database (base.db) in files folder

 

Attachments

• prueba.zip

  7.5 KB · Views: 289

Upvote 0

barx

Well-Known Member

Licensed User

Longtime User

• Nov 12, 2012

• #6

I haven't looked at your project but did you add the file to your project in the b4a ide? and you must, in your code, copy the database to a writeable location.

Search the forum for DBUtils, this helps simplify the process a bit.

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Nov 12, 2012

• #7

barx is right, you didn't copy the database to the File.DirInternal folder.
This code works having the database file in the Files folder of the project:

B4X:

Sub Activity_Create(FirstTime As Boolean)
    'Do not forget to load the layout file created with the visual designer. For example:
    Activity.LoadLayout("culturilla")
    If FirstTime = True AND File.Exists(File.DirInternal, "base.db") = False Then
        File.Copy(File.DirAssets, "base.db", File.DirInternal, "base.db")
    End If
    
    SQL1.Initialize(File.DirInternal, "base.db", True)
    
    la1=SQL1.ExecQuerySingleResult("SELECT pregunta FROM table1 WHERE id=1")
    
    Label1.Text=la1
End Sub

 

Upvote 0

F

fanfalveto

Active Member

Licensed User

Longtime User

• Nov 12, 2012

• #8

i try with dbutils,but i think the problem is with the database.I don´t know why.
Thank you anyway

 

Upvote 0

F

fanfalveto

Active Member

Licensed User

Longtime User

• Nov 12, 2012

• #9

I´m sorry Klaus but i can´t work your code.
The error is the same:no such table:table1

 

Upvote 0

F

fanfalveto

Active Member

Licensed User

Longtime User

• Nov 12, 2012

• #10

i delete the database and create other again,now runs ok.
Thank you very much

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Nov 12, 2012

• #11

Before I posted my code I tested it and it worked !

Best regards.

 

Upvote 0