A adrianomurta Member Licensed User Longtime User Oct 21, 2011 #1 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
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 B4X founder Staff member Licensed User Longtime User Oct 21, 2011 #2 Have you created a table? Can you post your code, including the logs? Upvote 0
luke2012 Well-Known Member Licensed User Longtime User Mar 24, 2012 #3 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! Upvote 0
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 Expert Licensed User Longtime User Mar 24, 2012 #4 You must give more information. Did you initialize the database. Are you sure that the table does exist ? etc. Best regards. Upvote 0
You must give more information. Did you initialize the database. Are you sure that the table does exist ? etc. Best regards.
luke2012 Well-Known Member Licensed User Longtime User Mar 24, 2012 #5 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. Upvote 0
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 B4X founder Staff member Licensed User Longtime User Mar 24, 2012 #6 Can you upload a small project with the database (or a subset of it)? Upvote 0
luke2012 Well-Known Member Licensed User Longtime User Mar 25, 2012 #7 project zip In attachment you can find the zip. The SQLite db is created with SQLite Expert IDE. Thanks in advance! Upvote 0
project zip In attachment you can find the zip. The SQLite db is created with SQLite Expert IDE. Thanks in advance!
klaus Expert Licensed User Longtime User Mar 25, 2012 #8 I just tried your project and it works without any problem in the Emulator and on my Nexus One . Best regards. Attachments SQLSpinner1.jpg 24.7 KB · Views: 428 SQLSpinner2.jpg 18.8 KB · Views: 439 Upvote 0
I just tried your project and it works without any problem in the Emulator and on my Nexus One . Best regards.
luke2012 Well-Known Member Licensed User Longtime User Mar 25, 2012 #9 Works also for me but if I delete all other project modules I have to do some test adding modules one by one. Upvote 0
Works also for me but if I delete all other project modules I have to do some test adding modules one by one.
klaus Expert Licensed User Longtime User Mar 25, 2012 #10 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. Upvote 0
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 Well-Known Member Licensed User Longtime User Mar 25, 2012 #11 Solved From my device I remove the apk e installed again and now works! Strange but it works Thanks you for your support! Upvote 0
Solved From my device I remove the apk e installed again and now works! Strange but it works Thanks you for your support!
