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 [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
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:[hidden email]] Im Auftrag von Aydin Ozgur Yagmur Gesendet: Montag, 23. März 2020 13:30 An: SQLite mailing list <[hidden email]> 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 [hidden email] 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 [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
"The mailing list is deprecated. You need to go to
https://sqlite.org/forum/ for the sqlite forum." ???? Can anyone give the source of this? On 23-3-2020 14:35, Hick Gunter wrote: > The mailing list is deprecated. You need to go tohttps://sqlite.org/forum/ for the sqlite forum. _______________________________________________ sqlite-users mailing list [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
On 24-3-2020 09:04, Luuk wrote: > "The mailing list is deprecated. You need to go to > https://sqlite.org/forum/ for the sqlite forum." ???? > > Can anyone give the source of this? No, i do NOT mean the source of the forum, but the source for "The list is deprecated" _______________________________________________ sqlite-users mailing list [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
It originally came from Dr Richard Hipp. It's official.
HTH Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: 27a Lidget Hill Pudsey West Yorkshire United Kingdom LS28 7LG Company Number: 05132767 On 24/03/2020 08:13, Luuk wrote: > > On 24-3-2020 09:04, Luuk wrote: >> "The mailing list is deprecated. You need to go to >> https://sqlite.org/forum/ for the sqlite forum." ???? >> >> Can anyone give the source of this? > > No, i do NOT mean the source of the forum, but the source for "The list > is deprecated" > > > _______________________________________________ > sqlite-users mailing list > [hidden email] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
In reply to this post by Luuk
> On Mar 24, 2020, at 09:13, Luuk <[hidden email]> wrote: > > No, i do NOT mean the source of the forum, but the source for "The list is deprecated" http://sqlite.1065341.n5.nabble.com/New-SQLite-Forum-established-this-mailing-list-is-deprecated-td111358.html But that's just DRH. The mailing list is fully functional. _______________________________________________ sqlite-users mailing list [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
In reply to this post by Luuk
See announcement on the mailing list dated march 12th
-----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:[hidden email]] Im Auftrag von Richard Hipp Gesendet: Donnerstag, 12. März 2020 21:18 An: General Discussion of SQLite Database <[hidden email]> Betreff: [EXTERNAL] [sqlite] New SQLite Forum established - this mailing list is deprecated I have set up an on-line forum as a replacement for this mailing list: https://sqlite.org/forum https://www.sqlite.org/forum/forumpost/a6a27d79ac Please consider subscribing to the new Forum. The intent is that the forum will eventually replace this mailing list. The Forum is powered by Fossil. It has been in active use in the Fossil community for a couple of years, and has worked well. See the second link above for more information. -- D. Richard Hipp [hidden email] _______________________________________________ -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:[hidden email]] Im Auftrag von Luuk Gesendet: Dienstag, 24. März 2020 09:13 An: [hidden email] Betreff: Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error] On 24-3-2020 09:04, Luuk wrote: > "The mailing list is deprecated. You need to go to > https://sqlite.org/forum/ for the sqlite forum." ???? > > Can anyone give the source of this? No, i do NOT mean the source of the forum, but the source for "The list is deprecated" _______________________________________________ sqlite-users mailing list [hidden email] 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 [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
OK i must have must the posts from the 12th of March till the end of
that week 😉, being busy with other things..... On 24-3-2020 09:19, Hick Gunter wrote: > See announcement on the mailing list dated march 12th > > -----Ursprüngliche Nachricht----- > Von: sqlite-users [mailto:[hidden email]] Im Auftrag von Richard Hipp > Gesendet: Donnerstag, 12. März 2020 21:18 > An: General Discussion of SQLite Database <[hidden email]> > Betreff: [EXTERNAL] [sqlite] New SQLite Forum established - this mailing list is deprecated > > I have set up an on-line forum as a replacement for this mailing list: > > https://sqlite.org/forum > https://www.sqlite.org/forum/forumpost/a6a27d79ac > > Please consider subscribing to the new Forum. The intent is that the forum will eventually replace this mailing list. > > The Forum is powered by Fossil. It has been in active use in the Fossil community for a couple of years, and has worked well. See the second link above for more information. > > -- > D. Richard Hipp > [hidden email] > _______________________________________________ > > > -----Ursprüngliche Nachricht----- > Von: sqlite-users [mailto:[hidden email]] Im Auftrag von Luuk > Gesendet: Dienstag, 24. März 2020 09:13 > An: [hidden email] > Betreff: Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error] > > > On 24-3-2020 09:04, Luuk wrote: >> "The mailing list is deprecated. You need to go to >> https://sqlite.org/forum/ for the sqlite forum." ???? >> >> Can anyone give the source of this? > No, i do NOT mean the source of the forum, but the source for "The list is deprecated" > > > _______________________________________________ > sqlite-users mailing list > [hidden email] > 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 > [hidden email] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users sqlite-users mailing list [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
Weren't we all...
When I requested working from home office on march 10th, the company went from "No, we can't do that until it is mandated by the law" to "Come to the office only if you can't work from home" in a matter of days. With "Please verify if you can access the company VPN from home" in between. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:[hidden email]] Im Auftrag von Luuk Gesendet: Dienstag, 24. März 2020 09:26 An: [hidden email] Betreff: Re: [sqlite] The mailing list is deprecated...... [was: Re: [EXTERNAL] No such column error] OK i must have must the posts from the 12th of March till the end of that week 😉, being busy with other things..... On 24-3-2020 09:19, Hick Gunter wrote: > See announcement on the mailing list dated march 12th > > -----Ursprüngliche Nachricht----- > Von: sqlite-users > [mailto:[hidden email]] Im Auftrag von > Richard Hipp > Gesendet: Donnerstag, 12. März 2020 21:18 > An: General Discussion of SQLite Database > <[hidden email]> > Betreff: [EXTERNAL] [sqlite] New SQLite Forum established - this > mailing list is deprecated > > I have set up an on-line forum as a replacement for this mailing list: > > https://sqlite.org/forum > https://www.sqlite.org/forum/forumpost/a6a27d79ac > > Please consider subscribing to the new Forum. The intent is that the forum will eventually replace this mailing list. > > The Forum is powered by Fossil. It has been in active use in the Fossil community for a couple of years, and has worked well. See the second link above for more information. > > -- > D. Richard Hipp > [hidden email] > _______________________________________________ > > > -----Ursprüngliche Nachricht----- > Von: sqlite-users > [mailto:[hidden email]] Im Auftrag von > Luuk > Gesendet: Dienstag, 24. März 2020 09:13 > An: [hidden email] > Betreff: Re: [sqlite] The mailing list is deprecated...... [was: Re: > [EXTERNAL] No such column error] > > > On 24-3-2020 09:04, Luuk wrote: >> "The mailing list is deprecated. You need to go to >> https://sqlite.org/forum/ for the sqlite forum." ???? >> >> Can anyone give the source of this? > No, i do NOT mean the source of the forum, but the source for "The list is deprecated" > > > _______________________________________________ > sqlite-users mailing list > [hidden email] > 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 > [hidden email] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users sqlite-users mailing list [hidden email] 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 [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
In reply to this post by Luuk
On 3/24/20, Luuk <[hidden email]> wrote:
> "The mailing list is deprecated. You need to go to > https://sqlite.org/forum/ for the sqlite forum." ???? > > Can anyone give the source of this? https://www.sqlite.org/support.html https://www.mail-archive.com/sqlite-users@.../msg119468.html -- D. Richard Hipp [hidden email] _______________________________________________ sqlite-users mailing list [hidden email] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users |
Free forum by Nabble | Edit this page |