Zeoslib Portal

While your solution looks great, it is not the affect I'm looking for. I want my application to remain responsive and let the user continue working while doing the calculations. If I could go fully multithreaded with TDataset I would, for example, start the calculations *before* the user asks for th...

Hi Jan, Sure I can do locks and critical sections and what not, but that is exactly what I'm trying to avoid... I have several use cases for such a thing, but the most pressing one is being able to show the TZQuery in a grid while being able to do some calculations in a different thread (i.e. not th...

Hi,

Is there a way to iterate the same dataset in 2 different threads? from the look of it the standard dataset.eof/first/next is not design for such a case

Thanks,
Yoni

You can use the the semicolon operator, you need to double it

so instead var::int
you write var::::int

":" is being used by zeos to parametrize the query, so it kind of conflicts with postgress, but as I said just double its number

I'm not sure what to tell you, I ran into this problem because I live in the real world :) But fundamentally speaking, every object that is made out of series of primitives is a good candidate for an array. A "polygon" is a good example, as it described as a series of points on the plain. ...

I don't think it is half dead. As I've seen many cases of these none trivial types.

That being said, and considering the constrains of resources zeos have I think that converting them to strings is acceptable approach (in binary mode) something I'm working on. But it will take time...

@marsupilami I've just experimented with BinaryWireResultMode=False , I used ZReadOnlyQuery 1. When copying the data to ZMemTable and viewing that MemTable in a gird I get the "Cannot access blob record in column with type String" 2. When showing the data in the grid directly from the ZRea...

@marsupilami @Mark @Fr0st Text vs. Binary / Correctnes vs. Speed Following this thread and another one I opened it is obvious that the current implemention of the Postgresql driver has bugs while interfacing with other components (ZMemTable, Grids etc..). With your help it was pinned down to the way...

I'm not sure that the case. CloneDataFrom doesn't trigger the error. Only when I present ZMemTable in the grid. So the cloning part works fine.

Hi, A query I work on has an array field in a results set. After copying it to ZMemTable the gird I'm using to present the data returns with the following error: "EZSQLException: Cannot access blob record in column 4 with type String". This error doesn't happen when I'm presenting the data...

@marsupilami - Can you point me to the code Egonhugeist wrote?

As a side note, Firefird/Inerbase also supports array fields. Does its driver support arrays?

@MJFShark - Thanks! I'll use that as a blueprint to the fix

Hi, In the database I work with there is a field defined as varchar(60)[] (which means it is an array field) when selecting it I get the following error: "Cannot access blob record in column 1 with type String" The error comes from TZRowAccessor.GetBlob function, it checks for the length o...

Hi, Sure. I removed the code and it does improve the performance. I'm using the PostgreSQL driver (connecting to server v13.2). Doing a rollback is very expensive, as you have a full roundtrip to the server . As aside note, there is also a bug that can lead to connection leakage when doing a rollbac...

A connection is being checked twice for being dead (by calling FConnections.Rollback) . Both when it is Acquired and when it is being returned to the pool (see TConnectionPool.ReturnToPool and TConnectionPool.Acquire ). Calling rollback is expensive. I believe that TConnectionPool.ReturnToPool call ...

It just so happen that I upgraded ZEOS lib today exactly after 366 days... And I noticed that the exe size increased by 400kb (on top of the ~3mb it was already adding). I do care about this thing for various reasons which are not the scope of this post. My question how can I pin point what cause it...