table problem using dbutils

[adrianomurta]

hi, i tryusing example SQLExample and work fine,

but when i use dbutils , show the error : table not found

can help me ?

sorry my english

TIA Adriano
Brazil

 

[Erel]

Have you created a table? Can you post your code, including the logs?

 

[luke2012]

I have the same problem.

Code :

DBUtils.ExecuteSpinner(Main.SQLEngine,"Select Nome_tavolo from tab_Tables",Null,0,spnTable)

error is : no such table ...

I verified the query in SQLite engnine and It works fine!

 

[klaus]

You must give more information.
Did you initialize the database.
Are you sure that the table does exist ?
etc.

Best regards.

 

[luke2012]

I confirm that the db is initialized and the table exist.

And I confirm that the Query "Select Nome_tavolo from tab_Tables" works if tested on SQLite Expert.

 

[Erel]

Can you upload a small project with the database (or a subset of it)?

 

[luke2012]

project zip

In attachment you can find the zip.
The SQLite db is created with SQLite Expert IDE.

Thanks in advance!

 

[klaus]

I just tried your project and it works without any problem in the Emulator and on my Nexus One .

Best regards.

 

[luke2012]

Works also for me but if I delete all other project modules
I have to do some test adding modules one by one.

 

[klaus]

Are you trying to initialize the database onece more in one of the modules ?
Do you use the variable 'TargetDir' somewhere else in your program ? It's declared local in Activity_Create.

Best regards.

 

[luke2012]

Solved

From my device I remove the apk e installed again and now works!
Strange but it works

Thanks you for your support!