Zeoslib Portal

Solved

I opened ticket
https://sourceforge.net/p/zeoslib/tickets/503/

demo project which demonstrating problem is in attacment

Hello. Parameter SchemaPattern is empty, but parameter Catalog hold the alias of the attached database. So I modified query by this way GetStatement.ExecuteQuery('select sql from '''+Catalog+'''.sqlite_master where name = '''+TableName+'''') and it is work correctly! What about second half question?...

Hello again! While working with the attached DB (sqlite feature), I discovered a new problem. When a query is made to a table from the attached DB, the following call chain is executed 1. TZSQLiteDatabaseMetadata.UncachedGetColumns 2. FillResult 3. IsAutoIncrement Function IsAutoIncrement executes t...

Fixed in r7395.

Are there plans to update the 7.2 release in the future?
Maybe 7.2.11 or 7.2.12?

I am currently considering whether to keep my projects on stable 7.2 or switch to trunk (8.0) and use it.

Got it.
Thanks a lot for the detailed clarification!

I reread the entire thread more closely. My apologies, it looks like I jumped to conclusions. The error remains due to the fact that I am still using starting a transaction before calling TZSQLProcessor.Execute Please explain in a little more detail why, when using TZSQLProcessor, you do not recomme...

I opened a ticket
https://sourceforge.net/p/zeoslib/tickets/496/

Hello. This problem still persists. Checked with current stable version zeos-7.2.10 When I looked under the debugger, I saw the following comment in the method TZAbstractConnection.Commit { TODO -oEgonHugeist : Change this code sequence on 7.3! My automation idea simply is wrong! A commit vs. commit...

Hello.

Sorry for the long silence.
I didn’t work on that project for a long time and now I came back to it again.

Checked the problem with current stable version zeos-7.2.10
As far as I can tell, this issue has been resolved.

Many thanks!

Hello. I found such a problem that the TZConnection.GetColumnNames method does not work correctly for tables containing uppercase characters, such as T01. My environment: Windows 8.1 x64 Delphi 2007 ZEOS version: 7.2.10-stable Database driver: SQLite (sqlite3.dll v3.34.1) At the same time, with ZEOS...

Hello,
Do you have any news about this?
I did checked it on Zeos 7.2.6-stable. The problem still stay.

Hello,
Yes, I did checked it. The problem still exists on Zeos 7.2.6-stable

Hello. I found a problem with ZSQLProcessor (7.2.4-stable) and SQLite when I execute some sql-script with creating temporary table . Without "create temporary table" all works fine. ZEOS 7.2.1-rc not reproduce this problem. My environment: Windows 8.1 x64 Lazarus 1.8.0 x32 FPC: 3.0.4 ZEOS ...

Hello! Sorry for the long silence - I did not receive a notification about your answer. My environment: Windows 8.1 x64 Lazarus 1.8.0 x32 FPC: 3.0.4 ZEOS version: I tried both 7.2.1-rc and 7.2.4-stable Database driver: SQLite (sqlite3.dll v3.18.0 in attachment) In the attachment is a project demonst...