Unidac returns wrong Data if TFieldType is ftDate (Filemaker/ODBC)
Posted: Mon 02 Mar 2020 07:20
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?
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?