Databases
StackOverflow2013
Postsdbo
POsqlite prepare statement error - no such table
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsqlite prepare statement error - no such table
    primarykey
    data
    text
    <p>I'm having some difficulty with my sqlite prepare statement. I get an error saying my table does not exist, although I've checked in multiple places for it, and it does exist, so I'm confuzzled. </p> <ul> <li>The file is in the correct iPhone Simulator Application folder </li> <li>The file is added to my project and viewable in the project navigator</li> <li>It is also in my build phases- Copy Bundle Resources area. </li> <li>I've cleaned and started running again.</li> <li><p>The database exists and running my sql statement gets me just the results I expected.</p> <pre><code>- (NSMutableArray *) getMyWorkout{ NSMutableArray *workoutArray = [[NSMutableArray alloc] init]; @try { NSFileManager *fileMgr = [NSFileManager defaultManager]; NSString *dbPath = [[[NSBundle mainBundle] resourcePath ]stringByAppendingPathComponent:@"IOSDB.sqlite"]; NSLog(@"Db path is %@",dbPath); BOOL success = [fileMgr fileExistsAtPath:dbPath]; if(!success) { NSLog(@"Cannot locate database file '%@'.", dbPath); } if(!(sqlite3_open([dbPath UTF8String], &amp;db) == SQLITE_OK)){ sqlite3_close(db); NSLog(@"Failed to open database with message '%s'.", sqlite3_errmsg(db)); } const char *sql = "SELECT Id, type, difficulty, duration, description FROM workoutTbl"; sqlite3_stmt *sqlStatement; if(sqlite3_prepare(db, sql, -1, &amp;sqlStatement, NULL) != SQLITE_OK){ NSLog(@"%s Prepare failure '%s' (%1d)", __FUNCTION__, sqlite3_errmsg(db), sqlite3_errcode(db)); } //... </code></pre></li> </ul> <p>When I run it, I get the file path and the following error</p> <pre><code> 2013-02-01 18:07:08.060 TriShake[9251:c07] -[MyWorkoutList getMyWorkout] Prepare failure 'no such table: workoutTbl' (1) </code></pre> <p>I've checked out these other questions, but have been unable to find a solution</p> <ul> <li><a href="https://stackoverflow.com/questions/12746484/sqlite-prepare-failed-no-such-tabletablename">Sqlite Prepare Failed: no such table&lt;tablename&gt;</a></li> <li><a href="https://stackoverflow.com/questions/672829/sqlite3-gives-no-such-table-error-on-iphone">Sqlite3 gives &quot;no such table&quot; error on iPhone</a></li> </ul> <p>I understand sqlite3_open() creates an empty database for you if the database path does not exist, but i know it exists, so frustration ensues. Any help or guidance you could give me would be much appreciated.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USnniroclax
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POsqlite prepare statement error - no such table
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt is exactly as it says... check your database for the table name and make sure it is correct. Make sure the tables name is `workoutTbl` with matched case. If the table does not exist, you will need to create it. It `may` create the database file for you, but you still need to create your table schema. If you have already created the table, please post your schema.
      singulars
      1. POsqlite prepare statement error - no such table
      1. USMatt Clark
    2. COFirst make sure you're dealing with the database you think you are. If you're trying to operate on a DB in the bundle you won't be able to modify it. And SQLite will happily create a new empty table if you somehow bungle the name. But SQLite is quite reliable in its messages. If it says there isn't a table by that name then there isn't.
      singulars
      1. POsqlite prepare statement error - no such table
      1. USHot Licks
    3. CO(Note that you may have a prototype DB in your project that you THINK is being included in the bundle but which isn't.)
      singulars
      1. POsqlite prepare statement error - no such table
      1. USHot Licks
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload