Subject | Problem with TIME field |
---|---|
Author | Salvatore Besso |
Post date | 2004-05-25T09:10:17Z |
hello all,
I have defined a domain as follow:
CREATE DOMAIN TM_QSO_TIME
AS TIME
NOT NULL;
and I have used it in the definition of a table:
...
Qso_Time TM_QSO_TIME,
...
I'm using the database (Firebird 1.5.0.4306 SS final) with a Delphi
application and I insert the correct value into this field by mean of
a Delphi statement, for example:
Query.FieldByName('Qso_Time').AsTime := '11.22.00';
But I have discovered that this field in all rows contains always
'00.00.00' (I have checked the database also with IBExpert). Is there
something wrong with the TIME data type in Firebird or do I have to
look in other places?
Regards
Salvatore
I have defined a domain as follow:
CREATE DOMAIN TM_QSO_TIME
AS TIME
NOT NULL;
and I have used it in the definition of a table:
...
Qso_Time TM_QSO_TIME,
...
I'm using the database (Firebird 1.5.0.4306 SS final) with a Delphi
application and I insert the correct value into this field by mean of
a Delphi statement, for example:
Query.FieldByName('Qso_Time').AsTime := '11.22.00';
But I have discovered that this field in all rows contains always
'00.00.00' (I have checked the database also with IBExpert). Is there
something wrong with the TIME data type in Firebird or do I have to
look in other places?
Regards
Salvatore