Unidac returns wrong Data if TFieldType is ftDate (Filemaker/ODBC)

[JoelH]

I use Unidac 8.1.2. for Rad Studio 10.2 and a 32bit ODBC-Connection

My Problem is the return of Date-Fields out of a Filemaker 16 Server.

If i use a Query like

SELECT mydatefield FROM Table

and the TFieldType from mydatefield is ftDate then i only receive 01.01.0100 back from the Server.

if i use

SELECT strval(mydatefield) FROM Table

or

SELECT DAY(mydatefield), MONTH(mydatefield), YEAR(mydatefield) FROM Table

i receive the Date as string and the Date is correct, or the single Numbers, also correct.

But this is not useable for me, because i do not know the Fieldnames and have to use SELECT * From Table.

Is this a Unidac issue?

[MaximG]

Please send us the DDL script for creating those tables that you've used in your example.