Can someone please explain this weird SQLite behavior to me? How do I fix this?

[Stagg54]

Why does this work in the SQLite DB browser, but not in LabVIEW?

And why I am getting this error, that basically should never happen? This: https://sqlite.org/rescode.html#mismatch says it should only ever happen when trying to set a rowid to something other than an integer. I'm not doing that.

[drjdpowell]

Can you attach a small VI demonstrating the error?

[FantasticNerd]

On 8/17/2021 at 7:28 PM, Stagg54 said:

This: https://sqlite.org/rescode.html#mismatch says it should only ever happen when trying to set a rowid to something other than an integer. I'm not doing that.

They say there are a few rare cases.  The mentioned one seems only be an example of one of these cases. I would say this is not a "complete list" of all cases.

The error occurs even if you have no DB Browser opened parallel? 

[Stagg54]

Yes, it was still occurring w/o db browser running in parallel. It appears to happen when reading an empty view composed of other views, but I have several views composed of other views and not all of them exhibit this behavior. My work around it just to catch the error and clear, since it only seems to occur when the view is empty. 

to Dr Powell, I could give you the VI. It is a simple SELECT statement. The trick is the database. It's rather complicated and involved. I was unable to distill it down to a simple example.

[drjdpowell]

Your DB Browser and LabVIEW are possibly using different versions of sqlite.  Can you run this in each to detect the version: 

select sqlite_version();