On Fri, 24 Mar 2006, Arí Ricardo Ody wrote:
> At 14:40 24/3/2006, Michael Van Canneyt wrote:
> >(I received a screenshot in private)
> >
> >Sounds like the error message is formatted wrong:
> >
> >Unknown field type: HREG_DIVDD
> >
> >Ricardo, it is not quite clear;
> >is the field type called HREG_DIVDD or is the field
> >called HREG_DIVDD ?
>
> Well excuse me. It seems to be obvious, but for people who don't know DB2...
> The field(a column, in fact) is called HREG_DIVDD and it has a field
> type of TIMESTAMP (it is a type of field recognized by DB2. Smallint,
> char, varchar, graphics, date, time, etc are other field types)
>
>
> > From the sources you sent me, I cannot see it.
> >Can you provide a "CREATE TABLE" SQL statement
> >for the table DB2PRD.TRANS_ONLINE_DIVDD ?
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 ?
Michael.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
