Page 1 of 1

Map Date fields to TSQLTimeStampField

Posted: Wed 16 Jun 2010 19:09
by esasse
Is it possible to make a date field in Firebird map to a TSQLTimeStampField in Delphi?

I have to support two databases with the same code, one uses date fields (Firebird) and in the other (MSSQL2005) all date fields are datetime fields. So I'm trying to figure out a way of doing this without changing date fields in Firebird to datetime.

Thanks

Posted: Thu 17 Jun 2010 07:56
by Dimon
DbxIda maps DATE fields to TDateField, and TIMESTAMP fields to TSQLTimeStampField. DbxSda maps DATETIME fields to TSQLTimeStampField.
To solve the problem use TIMESTAMP fields instead of DATE fields in Firebird.