Issue with Queries Containing More Than 21 Columns in Zeos

[gabrielbhz]

Hi,

I am migrating my Delphi + Mormot service solution to Lazarus + Mormot and replacing FireDAC with Zeos. I have encountered an issue when executing queries containing more than 21 columns. I receive the exception "EZSQLException with the message: SQL Error: Invalid host variable", on both Linux and Windows.

I am using the following versions in my setup:

Lazarus 3.4
FPC 3.2.2
mORMot 2
Zeos 8
Sybase SQL Anywhere 16 as the database
From my debugging so far, the exception occurs in the procedure TZAbstractASAStatement.DescribeCursor in the unit ZDbcASAStatement. It seems to happen when the DLL (FPlainDriver.dbpp_describe_cursor) is called, but I wasn't able to investigate further.

Has anyone experienced a similar issue or has any insights on how to resolve it?

Thank you in advance for your help.

[tintinux]

Hi

To be helped, maybe you could try to reduce the issue to a small sample, with a SQL statement to create a table and a small Lazarus project running the Query (previously checked with another SQL client).

Regards

[marsupilami]

Hello,

Which driver do you use? I think, the ASA driver is deprecated and the asa_capi driver is the one to use now.

Best regards, Jan