Page 2 of 2

Re: Writing Blobs from Streams Failing in SQLite... SOMETIMES...

Posted: 18.10.2022, 12:06
by Fr0sT
Well, common approach to solving almost any issue is localize it first. So trace all the lines up to DB client lib call and push checks here and there (luckily Zeos comes with sources so you can modify the code).

Another way is to find the exact Zeos commit which introduced the issue. If you say you've had no such issues with v7 then revert to v7 commit and then apply further commits til the issue appears. You can use Git's bisect feature to reduce iterations.

Btw, do you use the same SQLite lib when issue happens and when not? Maybe it's not a Zeos fault?

Re: Writing Blobs from Streams Failing in SQLite... SOMETIMES...

Posted: 20.10.2022, 03:41
by BytePlayer
Yes, the SQLLib is the same.

Okay, it just stopped doing it after I did nothing about it. Lovely, so much for tracking THAT down.

Quick question -- is there any way (short of writing a SQLLite Function) to send the binary data in an INSERT QUERY?

Re: Writing Blobs from Streams Failing in SQLite... SOMETIMES...

Posted: 20.10.2022, 06:35
by BytePlayer
Uh... never mind about what I said about it going away -- I had to set to suppress the messages outside of the IDE. But it's still happening so I guess I'll try reverting to some earlier versions...