Michael Van Canneyt wrote:
> Ok, so first of all the error message is somehow wrongly formatted,
instead of giving the ODBC field type, it only contains the field name
(it must do that too, of course), but fails to return the actual
'unrecognized' field type.
Looking in the ODBCConnection, I would suppose that the DB2 Timestamp is
translated to SQL_TYPE_UTCDATETIME:
SQL_TYPE_UTCDATETIME:FieldType:=ftUnknown;
SQL_TYPE_UTCTIME: FieldType:=ftUnknown;
As you can see, they are not recignized by the ODBC connection.
Joost, do you know why they are not recognized ?
No, I do :)
Sorry, I didn't notice this thread before; there was no 'ODBC' in the subject
line ;)
I guess that at the moment I wrote that code, I was unsure what to do with the
SQL_UTC(DATE)TIME datatypes, so I just mapped it to the unknown data type. I
will look at it again - maybe I had some more specific reason, but probably
not. Note that I currently have tested ODBCConnection only with the MyODBC and
.mdb ODBC drivers.
I will also look at the error message.
Bram
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
