Zeoslib Portal

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.

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