Zeoslib Portal

Hi, I think I may have tracked down the cause for the problem I reported in http://zeoslib.sourceforge.net/viewtopic.php?f=40&t=73973 : It seems that the metadata TZVirtualResultset which has been cached for some combination of tablename and property will be closed, when TZSQLMetadata.Close is c...

Hi, I am attaching a quick&dirty test project which demonstrates the problem I have with TZSQLMetadata. The form consists of an input field, a memo (for result output) and an edit field for input of a table name. A single TZSQLMetadata object and TZConnection object is used. You will have to adj...

Hi Jan, I got the current version from SVN and tried my test project. I do not think that the metadata bug has been fixed. Actually, the problem has gotten worse, because now, only the first open on the TZSQLMetadata for any one table will return results. If I close it and open it again, the grid wi...

Hello Jan, thank you very much for your response and your suggestions. I will try those. To answer your question: I deactivated the caching the hard way, i.e. by commenting out the line which inserts the resultset into the hashmap. I just wanted to see if it might be related to the cache... I have j...

Jan, thank you very much for your answer. I already switched back to the emulated prepared statements, but will yet have to try the doCalcDefaults option. I would like to take advantage of MySQLs automatic update of timestamps (using both DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP). I...

Hi, I try to use zeos (current stable version 7.2.4) in Delphi 10.2.3 with MySQL 5.7 community and the C Connector libmysql.dll version 6.01.11. I have been working on my project for several weeks now and it (worked more or less), until I found that the prepare was only emulated. The problem that pr...