Comments on: iPhone SQLite ‘no such table’ error

By: dmertl

dmertl — Thu, 11 Feb 2010 19:24:04 +0000

@abc If you delete the app from the simulator that should remove any databases. Then make sure that your database is bundled with your app and then you’re opening that database without any typos like I did.

You can always run “SELECT name FROM sqlite_master WHERE type = ‘table’” and check if there is anything in your database. If not either your bundled DB is empty, the OS is caching an empty version, or you’re not selecting the right DB name.

By: abc

abc — Thu, 11 Feb 2010 13:43:48 +0000

same problem,
did all the things,
deleted app from simulator, cleaned all the targets, deleted reference , made newer reference .. then also m facing the same thing,
in this case it got suddenly stopped .
i havent updated DB schema..

By: Dave

Dave — Wed, 18 Nov 2009 09:10:07 +0000

Never mind…I found the problem..Thanks.

By: Dave

Dave — Wed, 18 Nov 2009 07:50:50 +0000

I did everything clear, uninstall, reset simulator.. but still getting same error. It creates EMPTY DB before the sqlite3_open() statement..and I am surprised with that. Any Clue..??