Zeoslib Portal

I have downloaded and installed zeoslib-code-0-r6803-branches-testing-7.3.zip. It seems to have solved the
problem. No more SIGSEGV with ZQuery.Refresh.
I have tested with aforementioned libmysql.dll and libmariadb.dll.

Thank you for resolving this issue!
Cheers.

Ok - I will try to create a test case based on this information. That can take some days. Some more questions though: - Which version of MySQL do you use? - Which version of MySQL Connector/C do you use? Or do you use the libmysql.dll provided my the server? - Do you create a 32bits application or ...

Unfortunately the SIGSEGV still happens when I replace libmysql.dll with libmariadb.dll. According to properties of libmariadb.dll I am using is: - File version 3.0.0.7 - Product version 3.1.9 The code for connection to the database is: ... if not ZQuery1.Connection.Connected then begin // liblocati...

I have downgraded ZEOS from 7.3 to 7.2.6-stable and the exception doesn't get raised at ZQuery.Refresh.

Thank you.

I am creating a win32 bit application connecting with libmysql.dll version 6.1.6.0.
I have tested it with MySQL 8.0.18 Community Server x86_64 and MariaDB 5.5.57.

Cheers,
Wai-kit

Hi Jan, Yes, the query is refreshed by calling ZQuery.Refresh method. The code looks like if ZQuery.active then ZQuery.Refresh else ZQuery.Open Since the table has more fields of type Decimal(10,2) I have changed the SQL to: SELECT SaleAmount, AmountPaid, VatHigh, VatLow FROM tblSale WHERE DATE(Sale...

Hello, I have a table in a mysql database with a field defined as Decimal(10,2). To connect to this table I have a ZQuery component with the following SQL query: SELECT DATE(SaleDateTime), SUM(VatLow) FROM tblsale GROUP BY DATE(SaleDateTime) A DBGrid is connected to ZQuery. I can open the query, but...