SQLite Forum

sqlite3_prepare_v2 does not seem to work.
Login
@ Larry Brasfield,
This remark: "Is the current directory for your program's process the same as the directory in which "the_insert.db" resides? And is that the very same database that you are sure has a table named "someTable"?" made me thinking; and looking in the directory where Xcode used to put the executable.

Guess what!

1. Database and path created by Xcode:
/Users/janhkila/Library/Developer/Xcode/DerivedData/SQLite_Multiple_Insert_00-dksaovkjvqrrrzdodwcmnprrbxey/Build/Products/Debug/the_insert.db

2. Database and path created by me:
/Users/janhkila/SQL-Lite/the_insert.db

So, there are two identical databases "the_inser.db" both with a table "someTable", only in different directories.
Thank you very match Larry! And off course mr. Apple/Xcode.  Well not really.