Zeoslib Portal

Hello RedHead, we don't support Code Typhoon. Zeos 7.3.0-alpha is - as the name says - an alpha version. This version is really old and was never meant to be included in any stable software. Please uninstall this version and check wether the problem also happens with the current 8.0-patches branch f...

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. This is correct. Bookmarks are only meant to be used whil...

Hello Daniele, You could hook a TZSqlMonitor to your connextion and see if the statement gets executed. If it is in the log, it gets executed and you will have to take a look at the database side. Also it makes ense to look at the transaction management: Maybe the statement gets executed but the tra...

Hello Siegbert, that sounds strange. I maintain an application with Firebiord and didn't see that problöem yet. A test case that demonstrates the problem really would help. Could you please make sure that you update to the latest Zeos 8.0 revision from SVN (branches/8.0-patches) or from Github (8.0-...

Hmm - that sounds strange. Without a reproducible example it will be hard to debug. I could create a link on our nextcloud instance and send it to you via PN, so you could upload your project there. Could you create a log using TZSQLMonitor? Maybe that reveals something strange? With best regards, Jan

Hello, the code you mention usually doesn't do any reconnection. It is meant to clean up memory only. I seem to remember that there is / was a function in older mysql versions that tries to reconnect to the database, in the event of a connection loss. But I think that was changed in modern versions ...

Hello Marco, "Requested database driver was not found" means that you try to use a driver that Zeos doesn't know. Given your information, I can only do assumptions here. I assume that with Delphi 10.4 you use Zeos 7.2 or something older? Master currently contains a version of Zeos 8.0. One...

Hmmm - for me the following works as expected: procedure TForm1.Button1Click(Sender: TObject); var Conn: TZConnection; begin Conn := TZConnection.Create(self); Conn.Protocol := 'sqlite'; Conn.ControlsCodePage := cCP_UTF8; Conn.Database := 'D:\Projekte\Zeos\sqlite-x86-3390300\test.sqlite'; Conn.Libra...

Hello JD,

did you change something in the ZEOS.INC file? For me the following works as expected:

• Install Debian 12
• Install FPC 3.2.2 / Lazarus 2.6.2 using fpcupdeluxe
• Install the latest Zeos 8 from SVN

With best regards,

Jan

Hello JD,

which Linux distribution do you use and do you use the FPC and Lazarus version of that distribution or dou you install them yourself?

With best regards,

Jan

Hello Graham, I am not sure, if SQLite transaction support is started by default on Zeos 7.2. Could you please add the following line to TZConnection.Properties? ExtendedErrorMessage=1 This should enable SQLite extended error information. Maybe this will help in finding the problem. Best regards, Jan

Hello Renato,

I think the starting point for thius would be ZUpdateSqlEditor.pas in src\component. I assume, it contains the editor window for TZUpdateSQL. I didn't work on that code (yet) so I don't know what it looks like in there.

Best regards,

Jan

Hello iteh,

with current Zeos it simply isn't possible to use that mechanism. For me that clearly is a bug. You might want to check into doing your own notice processor or notice dispatcher. Simply replacing Zeos notice dispatcher and notice processor shouldn't do any harm.

With best regards,

Jan

Hello Renato,

unfortunately - no. There simply was no time to look at it yet.

With best regards,

Jan

Locked