Zeoslib Portal

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...

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?

I think I misspoke (mistyped?) when I said that they were too short. In all cases since then they have been too long... and as far as I can tell, it's not previous text that's being left over, it's a duplication of the final text... though it may be that it's only happening after it's been written o...

Well, sadly I did not accidentally fix it though I've gathered a bit more information and a pretty hackish work around. It seems to be happening exclusively during a "timed backup" which is an idle event where the program takes all the data is has been working with, and updates the databas...

Yes, as a software developer I completely get that. We'll see if it happens again for if I've somehow accidentally fixed it...

No joy replicating it either. I've put in some more checks/tests so if/when it happens again, I'll hopefully be able to give you more data...

Okay, I'll try but it's unfortunately erratic...

OMG, this is the most paranoid code I've ever seen... Thanks! I'm not normally this paranoid, but I was having some problems so I started putting checks in. And I ended up doing the loop in case the issue was due to some sort of race condition... Anyway it really doesn't check much. If you really a...

Excellent suggestion -- I will do that and report back.

As a matter of paranoia, I have my code make sure all blobs are written correctly, and every now and again with V8 (alexandria), I get an assertion that it failed to write all the data to the blob. It's always just a few dozen or so bytes short, but I kind of think I need them, unless Zeos/SQLite is...

Thanks guys! The FLinkedComponents was exactly what I needed.

As to the tokenizer issue I think that may really be using a pneumatic pile driver when a hammer will do. I think I just need to look at the table names following INSERT INTO, UPDATE and DELETE FROM and go from there.

In version 7.2.x I had subclassed the tzConnection component to add some convenience functions and there are two of them I am having no luck recreating in Version 8. The first is as follows, and since the fDatasets property has been removed, I don't know how to go about getting either the TableCount...

unit ZDbcCache; I was getting an access violation when I set the SortIndexFields value to two fields in a table. I tracked it down to the function CompareUnicodeCLob_Asc and discovered it was happening only when it was trying to compare a field with itself. I added an extra check to verify if the t...

In the Unit ZDbcResultSet; Could anyone explain to me why TZAbstractBlob.IsEmpty is defined as true when fBlobSize < 0 rather than fBLobSize < 1 ? I mean, if it has a blobsize of zero it has no content, right? Otherwise what is the differences between this and IsNull? function TZAbstractBlob.IsEmpty...

That would be great! I'd really appreciate it.