Jump to content

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

Recommended Posts

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? 

Link to comment

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.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.