Zeoslib Portal

Well, what I actually wanted to say was that there shouldn't be metadata queries at all when 'after scroll requerying'. I think you misunderstood 'reopening a connection'. Because to requery a detail table you don't have to reopen the connection, just the query. So all queries using the same TZConn...

Actually, there is a metadata cache built into zeoslib. And it should only load data at first use. I haven't debugged it for a long time, so there might be caching bugs. The code should be driver independent, I believe. Just the way the data is retrieved depends on the driver. During one connection...

Hello dfumagalli, usually Zeos needs to query meta data for building queries that delete, update and modify the data in your underlying database, for executing stored procedures and so on. As far as I know, Zeos does not cache meta data about a database by default but it gets the meta data, wheneve...

Hello, thank you for your reply. I see you mention this as a known issue (or feature :P ), I'd like to add some considerations about it because I believe they do affect ZEOS performance compared to other libraries. 1) I am already using TZReadOnlyQueries for all but 1 query components. What could st...

Hello, please pardon my utter ignorance about the inner mechanics of your beautiful library. I have developed a massively large and complex Delphi XE5 application that acts as "glue" between etherogeneous remote front end and MySQL 5 back ends. So far it's working pretty well but it's slow...

Sorry for my absence.. Busy currently. It isn't wrong, the more it WAS wrong before 7.2. As Michal did alredy wrote SQLite has a maximum of 2147483647 Characters but TString/WideStringField has a Maximum of 8KB. So the Columns won't fit and a unwanted trunkation happens. 7.12 and older did use 255 ...

Here is the end result of this issue: a "real world" application that used to show certain data with ZEOS 7.1.2 and that now shows "Memo" in the string fields: Notice how the DBGrids show correct data because they are pulling data from another database engine and not using ZEOS. ...

@ dfumagalli What lengths should be presented VARCHAR? 2147483647; because so many allows SQLite specification. Michal I am sorry, I am not really knowledgeable about database internals, all I can say is that in Delphi 2010 + ZEOS 7.12 my applications show those fields as they should (strings) and ...

Hello, I have installed the latest snapshot (3070) on my RAD Studio XE5 Ultimate Update 2. I have only checked the 32 bit version so far as I have stuff to port over from Delphi 2010. I need to connect my software (also) to SQLite. I got the latest DLL version, downloaded 1 week ago from the officia...