Zeoslib Portal

I'd argue against setting the DCU location in the library path for multiple reasons: - If a developer is changing anything in the source, recompiling the affected package each time to be able to test the change is unnecessary - If a user clones Zeos from Git / downloads the .zip from SF, after each ...

What exactly do you mean by "FClientCP identifier compilation error"? Can you please post the exact error message? Installation steps roughly are... 1, Extract the package somewhere 2, Add Zeos's source, and it's subdirectories to your library path 3, Open the .groupproj for your Delphi ve...

As far as I remember all bookmarks become invalid if you close and reopen (refresh) a dataset. You can solve what you are looking for is taking the value of all index fields prior and use TDataSet.Locate on the same fields after the refresh. P.s.: depending on your Delphi version FreeBookMark is no ...

Hello,

Do you mean SSL? Afaik Zeos does support it, there were only issues with the library. Switching to LibMariaDB solved those aswell.

Do you receive any error messages?

Well, the code-breaking but more elegant solution is waiting on GitHub to be applied :)

Hello, I recently got a request (of course when I should be on vacation, whenever else...) if I can implement multiple command execution in my tool. Zeos has me covered with TZSQLProcessor but I have to keep a standardized output... for one query it was simply "x record(s) affected", now I...

In this sample does not exists zMemTable1.CreateDataSet, can I continue without that? Yes, that is correct. but there is not FindKey method, how to find them? Unfortunately I cannot help you wit index fields as I never used them, but you can locate even non-index fields: If Not ZMemTable1.Locate('f...

How do you do that if the primary key of a table doesn't get used in any foreign key? Does it work then? No, not at all. In that case repositioning won't be possible (or inaccurate) but for my purpose it's not a huge deal. I'll take a look at the advices above once my new feature is completely erro...

Disclaimer: take my answer with a grain of salt as I'm not using PostgreSQL anywhere. My reply has no experience, and only a quick code check behind it. Fconn: libpq is reentrant (by relevant doc of postgres team). But I can image situation where just before calling AbortOperation() from another thr...

I solved my issue by imported and exported keys in the mean time which seem to be doing the trick for my purpose.
However it would be really nice if we could get TField.IsIndexField working under Zeos :)

Any async code inside Zeos will add much of complicated code and create classes, that do many things. Clearly, it is not a good design. Have a look at APL in TComponent. Or System.Net.Socket.TSocket. Begin*() all over the code. What for? ZMethodInThread is good enough for start. In this context TZM...

Hello, I had this need already but always could get around it with bookmarks instead. I have a query (which can be a TZReadOnlyQuery or TZQuery) with an "unknown" select query. I need to find which fields are index fields on a database level, based on which values I can find the exact same...

Yes, this is the standard date format in Hungary (where I live). I don't know which library you mean, because built-in RTL functions do handle "multi-char" delimiters (up to 2, that is) fine. The only issue on D11+ was that it's not accepting "2023. 06. 17" because it requires th...

It's important here to mention the IDE used. Delphi 11 changed how date parsing is done and it caused our software at work to start failing at almost any point. Edit: 2 things. 1, Infinite loop? If I'm trying to feed it with a value surely different from my LongDateFormat, it simply crashes with a r...

Note: Is it correct that the CSV file is encoded in WIN1252? Yes, it is and no, it is not :D I'm simply calling If sl.Count > 0 Then sl.SaveToFile(Self.FileName); to save the export file so it's normal that it is using my codepage. In this era it definitely should be UTF8 though so you just pointed...