Zeoslib Portal

it was my mistake

later on in the application I changed the SQL programmatically. I had added this about 6 years ago and hadn't thought to customize it in the code in addition to the SQL in the TZQuery (for configuring at design time) when adding the new fields.

regards
Siegbert

Hello, I don't know if this is a Zeos-error, a Delphi error or my mistake :-( I have the query as you can see in the attachment (I can only put it in as Image, inserting the select as code leads to be blocked by sourceforge) I can add all field in the Delph field-editor but not the fields assigner b...

Hello, I am testing migration from FB 2.5 to FB 4 with the embedded Version of Firebird. In embedded Version of firebird 4 it is possible, to open a Database-File that has Version 2.5. My Delphi-application does not recognize that there is an old ODS-version. I don't want this kind of mismatching us...

Hello,

i changed again to transaction-Isolation tiReadCommitted and now ist works.
I don't know why it didn't work immediately

Siegbert
is it possible to mark a thread as solved?

.. the error message may be helpful. Is the deadlock only a second error and the original error is "Unsuccessful execution caused by an unavailable resource"? SQL Error: deadlock; GDS Code: 335544336; deadlock; update conflicts with concurrent update; GDS Code: 335544451; Unsuccessful exec...

Hello, i use this code to save form-position and size on closing the form in "onClose-Event of the form. If used on two working places it sometimes chrashes with an deadlock. For example: open a form in one session open the same form in the second session close the first form -> size an positio...

Hello, i have a problem with Firebird blobs. Zeos Connection shows "8.0.0-beta" as version. Firebird version is 2.5. Problem: I can write a record with an empty blob without problems. Even changing the empty blob to contain some characters and save the record works fine. But every saving w...

... with 7.2.14 patch for Delphi 11 all works fine!
Thanks to miab3 for the hint to that patch

Hello, @miab3:thank you for this hint - i found the patch in the subversion-tab :-) @aehimself: thank you for thie hint to get some more information. I was able to find out that the error is not happening in the suspected SQL, but in a query that is connected as a slave to the master query. Here is ...

Hello, my code worked fine with Delphi 10.4 and ZeosLib 7.2.14 and Firebird 2.5. But I need ZeosLib for Delphi 11 and only found 8.00-beta. Maybe there is a stable version I didn't find? In ZeosLib 8.00 I get a problem with ZDBcCache using this code which uses a prepared SQL-String, adds a where-cla...

Hello, I use ZEOSLib 7.2.6 stable in Delphi 2010 to create a report (FastReports Release 6) with about 1.000 ID-cards with a photography on the card. Database is Firebird 2.5. The report selects about 1.000 records each with a picture in a blob filed. The picture-size is about 250kbytes as .jpg-file...