Zeoslib Portal

on drivers that need their data fetched into memory, we usually do that internally (dblib) or have the client library handle this (mysql, postgresql). Well, since only the first 10 records are fetched (it's the dataset doing it, not zeos) I don't know how you can do that. I guess that it wouldn't m...

Here it is (I used 7.1.4 and 7.2.12, for 8.0.0 you'll have to change the protocol from sqlite-3 to sqlite)

https://drive.google.com/file/d/1MhweRc ... sp=sharing

Note that since the problem comes from TDataSet->TZAbstractRODataset (the sqlite specific bit is quite low in the hierarchy) it should affect all the other drivers, but maybe with a real server it is masked by its concurrency management.

8.0.0 behaves the same as 7.2.12, the sequence of calls (reverse call stack) once opened is: TDataSet.RecalcBufListSize TDataSet.GetNextRecords TZAbstractRODataset.GetRecord TZAbstracrRODataset.FetchRows TZAbstractRODataset.FetchOneRow TZAbstractResultSet.Next TZCachedResultSet.MoveAbsolute TZCached...

As I said in the first message, I already tried 8.0.0. I didn't debug like I did 7.1.4/7.2.12 though. I'm doing it now.
Switching to 8.0.0 is kinda of a pain due to the changes in the package layout and the change from sqlite-3 to sqlite (edit: oh, and the TZParam).

Slowly getting there: the old zeos, when opening a query, fetched all the records all by itself, the new one relies on the dataset to to that, however the dataset only fetches the first 10 records, that's why the statement is not reset. The sqldb TSQLQuery component has a "PacketRecords" p...

After adding more writelns (in methods step, finalize and reset of the plain driver) I found that for some of the queries the sqlite statement aren't reset with 7.2.12 (hence keeping the database locked) while they are reset in 7.1.4. I couldn't find the cause yet, it's a TZReadOnlyQuery with a simp...

Hello, I rebuilt an old project with the (almost) latest lazarus 3.2/fpc 3.2.2, windows 32 bits. Just one connection to an sqlite3 database with tiNone transaction and AutoCommit, an extension and a bunch of TZQuery/TZReadOnlyQuery to show the data in TDBGrids. Foreign keys are enabled. I realized t...

Ok, the second problem is solved by adding a Undefined_Varchar_AsString_Length=xxx property (thanks to EgonHugeist who replied to my bug here ). Apparently this also solved the first problem (the SIGSEV). The third problems is still pending, I opened this bug for it. Edit: link to second bug corrected

Hello, since I need some features in trunk, I tried both trunk and then 7.2 stable with my existing projects using sqlite-3. The short version: they don't work anymore :( if in a TZQuery/TZReadonlyQuery I use the already defined fields, I get a sigsev (sometimes when opening a query, sometime after ...