Map Date fields to TSQLTimeStampField

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for InterBase & Firebird in Delphi and C++Builder
Post Reply
esasse
Posts: 47
Joined: Tue 27 Nov 2007 19:08
Location: Brazil

Map Date fields to TSQLTimeStampField

Post by esasse » Wed 16 Jun 2010 19:09

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

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 17 Jun 2010 07:56

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.

Post Reply