Map Date fields to TSQLTimeStampField

Map Date fields to TSQLTimeStampField

Postby 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.

Posts: 47
Joined: Tue 27 Nov 2007 19:08
Location: Brazil

Postby 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.
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Return to dbExpress driver for InterBase & Firebird