Devart Forums

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

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

How come you ship a product that doesn't even compile?
What a shame!

When I try to compile the driver with my application using Delphi XE I get:

[DCC Fatal Error] dbexp.pas(23): F1026 File not found: 'DBXpress.dcu'

Version 2.70.26

I have some valid SELECT statements that when I send to MSSQL2005 sometimes return the error "Cursor not returned from Query".

It happens with different queries that work fine 99% of the time, and the only thing they all have in common is the use of several joins and some group by. Pretty standard queries.

How can I trace this and find out what's wrong?

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

Ok, forget it, my problem is that in Firebird I use a lot of date fields, that are not supported by SQL 2005, so there I've created datetime fields.

What I have to do is convert my date/time fields in Firebird to timestamp fields.

Thanks.

Didn't work.

I'm trying to have the same code base for Firebird and MSSQL. I'm using Devart's driver to access both, but in MSSQL, Datetime fields are read as TSQLTimeStampFields instead of TDateTimeFields.

How can I solve this?

[DCC Error] DbxIdaDriverLoader.pas(103): E2003 Undeclared identifier: 'FDBXWritableRow_SetUInt8'
[DCC Error] DbxIdaDriverLoader.pas(103): E2003 Undeclared identifier: 'TDBXWritableRow_SetUInt8'
[DCC Error] DbxIdaDriverLoader.pas(104): E2003 Undeclared identifier: 'FDBXWritableRow_SetInt8'
[DCC Error] DbxIdaDriverLoader.pas(104): E2003 Undeclared identifier: 'TDBXWritableRow_SetInt8'
[DCC Error] DbxIdaDriverLoader.pas(105): E2003 Undeclared identifier: 'FDBXWritableRow_SetSingle'
[DCC Error] DbxIdaDriverLoader.pas(105): E2003 Undeclared identifier: 'TDBXWritableRow_SetSingle'
[DCC Error] DbxIdaDriverLoader.pas(106): E2003 Undeclared identifier: 'FDBXWritableRow_SetTimeStampOffset'
[DCC Error] DbxIdaDriverLoader.pas(106): E2003 Undeclared identifier: 'TDBXWritableRow_SetTimeStampOffset'

I can't believe how this type of error can pass your QA.

Actually this is not a problem with compiling both drivers in the same project. The new DbxIda sources doesn't compile at all in Delphi 2009.

I still can't compile both together after upgrading to latest.
DbxIda 2.50.18 and DbxSda 4.55.19.

Delphi 2009.

The error is:

[DCC Error] DbxIdaDriverLoader.pas(103): E2003 Undeclared identifier: 'FDBXWritableRow_SetUInt8'
[DCC Error] DbxIdaDriverLoader.pas(103): E2003 Undeclared identifier: 'TDBXWritableRow_SetUInt8'
[DCC Error] DbxIdaDriverLoader.pas(104): E2003 Undeclared identifier: 'FDBXWritableRow_SetInt8'
[DCC Error] DbxIdaDriverLoader.pas(104): E2003 Undeclared identifier: 'TDBXWritableRow_SetInt8'
[DCC Error] DbxIdaDriverLoader.pas(105): E2003 Undeclared identifier: 'FDBXWritableRow_SetSingle'
[DCC Error] DbxIdaDriverLoader.pas(105): E2003 Undeclared identifier: 'TDBXWritableRow_SetSingle'
[DCC Error] DbxIdaDriverLoader.pas(106): E2003 Undeclared identifier: 'FDBXWritableRow_SetTimeStampOffset'
[DCC Error] DbxIdaDriverLoader.pas(106): E2003 Undeclared identifier: 'TDBXWritableRow_SetTimeStampOffset'

My project compiles the source code of both drivers in the same project.

But looks like I can't compile DbxIda 2.40.16 and DbxSda 4.45.18 in the same project because there was changes to a base class that are different in each version.

Can you confirm this? Am I doing something wrong?

When do you plan to release a version that supports Delphi 2010?

The latest. 4.45.15.