2021r2 has bugs, r2.1 was being prepared to fix some, and one was related to a SQLITE instability, a DB error I consider a serious one. It was marked as fixed BUT NOT INCLUDED in the release, it was postponed. So I consider all the R2.x series a fail and will wait R3.
First of all, the issue that came up does not manifest in everyoneās projects. I donāt believe we have a clear understanding of why it was showing up in Thomās project in the first place. Weāre using 2021r2.1 for internal projects that use SQLite without this exception showing up at all yet.
Second, yes, we fixed it before 2.1 shipped but it was decided that the change was not safe for a the short cycle of a point release.
Third, if youāre going to quote someone, at least take a moment to put the personās name on your post so people can consider the source.
Please post detailed information instead of a vague āSQLite doesnāt workā. I donāt get the exception so I donāt consider 2021r2 a āfailā.
Which part of āYou have to ask Rick as Iām not in the beta tester groupā would you like me to explain?
Or do you prefer to have some people run into the problem without any awareness of where the problem might be?
I donāt know about you, but I use SQLite, and if there is a problem - that according to Greg is fixed but the fix has not been released yet - then I would like to know about it.
Oh good. Thatās MUCH better then. No need to worry or even know about it ā¦
But seriously, Iām more worried about bugs that I do NOT know about than about those I DO and might be able to avoid or work around.
So you confirmed a bug, you fixed it, but you donāt want people to know about it even though it is in the current released version? Okaaaay ā¦
People should now consider the source before reading about a bug? Oh, Iāll happily link to the original post so people can āconsider the sourceā, but you have to explain that to those that are so prone to edit or remove posts to outside information (and if you get banned then donāt say I didnāt warn you).
And I think you would be really hard-pressed to name even ONE instance where I was not relying on good sources.
I never said that we donāt want people to know about it. What Iām asking for is that you not be so dramatic about it.
As a long time user of the product, people will take your statements with a certain amount of weight. If you had simply stated the issue with sqlite and a link to the already existing discussion, that would have been okay. But a general statement saying not to use the release isnāt.
But you didnāt cite your source at all in the original post. You could have just as easily put in a āquoteā that the Xojo IDE will turn your skin blue if you use it. Without knowing where the information comes from, one could think that it came from anywhere. And yes, I did track it down last night before I replied to you, and IMHO, if Rick wanted to say this on our forum, he should have done it himself, not anonymously through you.
Why? Sorting in SQL is done with ORDER BY. Iām not saying they donāt exist, but Iām not aware of any engines that consider āsortā a reserved word.
I once had PostGresā PgAdmin give me a warning for using the field name āNameā. It still worked OK, but made me more cautious in how I named my variables.
Even if it works, someone else might have to read/edit it one day and may remove it, thinking itās an SQL bug.
Never said such thing here. Never said anything āthroughā others. BOTH OF YOU are wrong here. If someone allow me to quote myself from the testers area, I will, if not, I wonāt.