Devart Forums

Is it possible to change the default mapping of fields?

I want my DATE fields in Firebird to come as TSQLTimeStampField instead of TDateField.

I explain why: In MSSQL 2005, there is no DATE field, only DATETIME, and I want to make a single code compatible with both without changing my DATE fields in Firebird to DATETIME. Of course, in Firebird the time part would be discarded during convertion.

Thanks

Hello,

DbxIda maps DATE fields to TDateField, and TIMESTAMP fields to TSQLTimeStampField. DbxSda maps DATETIME fields to TSQLTimeStampField. DbxIda and DbxSda don't map any fields to TDateTimeField, because dbExpress supports only TSQLTimeStampField fields. You can find more detailed information about it in the Readme.html file.
To obtain the functionality you want, you should change DATE fields in your Firebird database to TIMESTAMP fields.

So there is no way to tell DbxIda to map DATE fields in Firebird to TSQLTimeStampField?

For the time being dbExpress driver for Interbase doesn't support such functionality.