The mailing list is deprecated. You need to go to https://sqlite.org/forum/ for the sqlite forum.
Can you replicate the problem while using the sqlite shell? Are you checking column names returned from the second statement? Note that a.BIRTH.YYY from your example looks a bit weird for a qualified column name. My guess is that you are either not accessing the database file you want (rumor has it that windows has some strange goings on under the hood for certain file locations) or not handling transactions properly. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Aydin Ozgur Yagmur Gesendet: Montag, 23. März 2020 13:30 An: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Betreff: [EXTERNAL] [sqlite] No such column error I have been developing a c++ program in windows. In this program, in a loop, I open database, query and update the records then close it. I am encountering randomly with "No such column error". Query looks like that (but there are more columns than this STATUS table): "select a.BIRTH_DATE, a.BIRTH_PLACE, a.BIRTH_XXX, a.BIRTH.YYY from STATUS a;" I randomly encounter with this error while executing sqlite3_prepare_v2 method. When encountered this error, I made a second execution of sqlite3_prepare_v2 with "select * from STATUS a;" statement. Return value was SQLITE_OK. Do you have any idea what is going on? Thank you very much in advance, _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
