Zeoslib Portal

Hi, Reading the code I found something that I don’t fully understand and I hope someone can clarify it. TZCustomElementList has 2 properties Count and Capacity. Count being the actual number of elements in the list and Capacity being the size of the memory allocated for the list. Capacity must be eq...

Thanks, I now understand the interface. connection lost will always raise an exception.

In TZAbstractConnection.ConnectionLost the event is never considered to be raised i.e. EventErrorRaised is always False. It should be set under an else statement https://github.com/frones/ZeosLib/blob/3ae28b19e1ee7e7d5326869850097795faffe888/src/component/ZAbstractConnection.pas#L1032 p.s. I think r...

I would also like to recommend a change of code in TZDbcPooledConnection.AbortOperation , The way it works now is that if it doesn't have a connection it obtain one only to abort it immediately. This is a waste. It should first check whatever the connection IsClosed and if not try to abort it. if it...

It feels like this was copied form JDBC design where you have checked exceptions, so the user knows to try and catch AbortOperation. But in pascal it makes less sense At least in that regard the sqlite driver behave differently has it doesn't raise any exception. Also in TZAbstractConnection: functi...

There is a mismatch between the return values from AbortOperation (I refer to the last version I'm using but that seems to be going on for some time https://github.com/frones/ZeosLib/tree/3ae28b19e1ee7e7d5326869850097795faffe888/src) TZSQLiteConnection.AbortOperation always returns 1 TZPostgreSQLCon...

Hi, How do I disable the preparing of statements? I tried to remove [doPreferPrepared] from the dataset options but it doesn't help For quickly reproducer example, if I set the SQL to be: select * from files limit 20; select * from files limit 10 I get the error: "SQL Error: ERROR: cannot inser...

The old library works perfectly.

I never said it is a zeos problem, it can be the client library problem or lazarus problem too.

I'm looking for ideas on how to debug this.

I recently upgraded postgresql client library version from V13 to V15. Everything works except when closing the application in *debug* mode I get an expectation "EXTERNAL Access Violation" . I recreated this exception with the most simple application with the latest ZEOS8.0 version (The er...

Do you really think there are usecases where data will be interchanged between Zeos applications First, I can easily see this used within the same organization. And not having to write low level parsing routine would be a great usability feature. Also not having such a feature would exclude the use...

Hi Jan, The main drawback for implementing it this way is making the file *unportable* between applications. I'm not inventing anything new here, if you take a look at the specifications of the JPEG (exif) file format you will see the UserComment Tag, you can basically store any information along si...

I would like to suggest and request 2 changes to TZMemTable that will make it much more useful and future proof 1. Make the first byte of the file a version number of the format, if in future version when the file layout will change it would be much much easier to write a code that supports older ve...

I've just seen this message... I missed it...

Yes, the changes looks correct.

There are some wrong definitions in ZPlainSqLiteDriver, nothing big but it affects anyone who will try to work with SQLite directly Current code (as of 2023/1/17) type Tsqlite3_destructor_type = procedure(user: pointer); cdecl; SQLITE_STATIC = procedure(User: Pointer = Nil); cdecl; SQLITE_TRANSIENT ...

I would like to thank you both for the suggestions and the time and effort you put into this question.

No easy solution indeed.