Zeoslib Portal

Hello, currently I can't help with this. I added a test to the Zeos test suite, which should demonstrate your problem: procedure ZTestCompInterbaseBugReport.TestForum225651; var T1, T2: TZTransaction; Q1, Q2: TZQuery; function CreateTransaction: TZTransaction; begin Result := TZTransaction.Create(ni...

Hello Son,

I think we solved the problem. Please thest the latest 8.0-patches branch.

Best regards,

Jan

Hello Med,

Zeos stores these records in a cache. By changing the ShowRecordTypes property, you can get Zeos to show the deleted records again.

Note: In most cases using CachedUpdates doesn't make sense anymore. Please use the transaction capabilities of your database instead.

Best regards,

Jan

Hello Med,

I am not sure, I understand your question correctly. But the value for "after apply update" should simply be the current value that you can access by using Value or one of the AsXXXX-methods?

Best regards,

Jan

Ok, thanks for the reply. Unfortunately it will take some time, before I can do a test. I first have to familiarize myself with Android development on Lazarus/Freepascal.

Hello, this example lacks some necessary information: -> What SQL queries do you feed into Qry1 and Qry2? -> What outcome do you expect? -> What outcome do you see? -> What is the selected Transaction Isolation Level in the Basic connection and in the TZTransaction components? -> Which database do y...

Duh - hmm - I don't have a clue (yet). The problem is that I cannot test for this target at all. I will have to see if I can set up a test environment. Could you do a small test if this also happens with the FPC builtin components?

Hello Attila, as far as documentation goes, Zeos doesn't use pfInKey. As for pfInUpdate and pfInWhere this is what the documentation says: Fields that don’t have the pfInUpdate flag set will not get updated by Zeos. Fields that don’t have the pfInWhere flag set will not get used for constructing the...

Hello marko,

Zeos 8.0 is a point release and only works with FPC 3.2.2. If you want or need to use a newer fpc version, please try the 8.0-patches branch from Subversion or Github.

Best regards,

Jan

Hello tintinux, it seems you are using the "procedure LoadFromFile(const FileName: String; BlobType: TBlobType)" overload. This overload is depreceated. Depending on what you want to load, you might want to switch to using to one of the code page aware overloads of LoadFromFile or to one o...

Hello Hatti, Zeos 8 now (correctly) detects that your ID field is required. Zeos will also consider to use it for updates if it is a promary key. Zeos doesn't detect that the field value gets filled in by a trigger. Also a big problem for Zeos would be that it doesn't know the primary key value for ...

Hello, your sample works for me, but I had to do some adjustments. Here is what I did: Install Alma Linux 9 Add Extra Packages for Enterprise Linux: sudo dnf install epel-release Install Firebird: sudo dnf install firebird create sysdba: gsec -add sysdba -pw masterkey create a database with isql (is...

Sorry for resurrecting this thread lol... this would make a LOT of sense, but... since we are storing the TnsNames identifier in the Database property it would be hard to impossible to determine whether we need the EasyConnect syntax or we just let oci to try to resolve it. Yes, we can say if the h...

Hello, An unhandled exception occurred at $00000000004813D0: EDatabaseError: Operation cannot be performed on an inactive dataset The error in you stack trace isn't an access violation. It is: "EDatabaseError: Operation cannot be performed on an inactive dataset". Normally this happens whe...

automacaosamos wrote: ↑08.10.2024, 17:07 compilation is done normally, on Windows using the crossCompiler.

Ok - in that case I will rephrase my request: Please use the native linux compiler and check what happens. If you still have a problem then, please provide a minimum working example that shows the problem.

Best regards,

Jan