Zeoslib Portal

Duh - as far as I remember, PL/SQL is installed with the express versions of Oracle. So it should be possible. Maybe you could give some example on how to do that?

I applied the patch. Thank you for the contribution.

Hello Acke,

please post an example of code that generates the problem. This helps us in debugging.

With best regards,

Jan

RefreshSQl is used for refreshing a single row. In your example it could be something like:

Hello acke. This is expected. What is the problem?

ZUpdateSQL usuall is only necessary if you want queries that query from more than one table to become writable or if you want to make a readonly view writable or a selectable stored procedure or something like that. For most tasks it isn't necessary. TZQuery tries to build the correct statements for...

Hello Bruce, a systematic documentation isone of our weaknesses currently. There is a collection of old documentation in the files section on SourceForge . That should give you a starting point. If you are in doubt on how to use things or how to solve a problem, please don't hesitate to ask on the f...

Hello Bruce,

Zeos 8 will be released during the next weeks. We are currently fixing two bugs which I don't want to see in the official release.

With best regards,

Jan

Hello Renato,

currently this is a known issue that I cannot fix. There are other bugs that have to be fixed first.

With best regards,

Jan

Using ZUpdateSQL usually is only intended if Zeos cannot figure out things for itself. Like when you do a join and want rows to be updateable. For the standard cases ('select field1, field2, field3 from sometable where ....') usually it isn't necessary to use TZUpdateSQL. RefreshSQL is a statement t...

Honestly I don't use these generators. I simply write my SQL into the properties.

Also I wonder if you really need to use TZUpdateSQL.

Hello atendimentobed, the problem is the combination of using TZUpdateSQL and having no valid RefreshSQL in TZUpdateSQL. With TZUpdateSQL you tell Zeos to not worry about data and that you will take care of everything. So - you insert a record but provide no value for the ID field. Zeos assumes that...

As I said - I would ignore the problem since it is only visible in the debugger. The message seems to imply that the access violation happens during the last phases of the tear down of the application where FPC already has given control over access violations back to the operating system. It might b...

The first behavior with the EZDatabaseConnectionLostError is the expected behavior. Maybe you want to upgrade your client and see what happens. You could test the Mariadb Connector/C.

stoffman wrote: ↑04.05.2023, 07:39 I recently upgraded postgresql client library version from V13 to V15.

Maybe it isn't a problem in Zeos but in the PostgreSQL client library? What happens if you use the old client library?

Honestly I would ignore the problem if it only is visible in the debugger.