DOA 4.1 returns -1 for DATE columns in Delphi 2007

[plpolak]

Hello,

I am compiling my program in Delphi 2007 (update 1) with DOA 4.1 beta 2. This appears to return -1 for all DATE fields in the database (and thus display 30/12/1899). This can be reproduced by putting a DBGrid on a simple form with a TOracleDataSet.

When compiling the same application on Delphi 7 (with DOA 4.1b2), it works fine. It also works fine on Delphi 2007 with DOA 4.0.7.1

When can we expect the final version of DOA 4.1, and will this be fixed in the release?

regards, Pieter

 

[Marco Kalter]

We'll check it out. Version 4.1 will be out shortly.

 

[plpolak]

Can you give me a status on this Marco? We really are in need for a fix, as our current program doesn't work properly with the existing 4.0 version (caused by the XmlType bug in Oracle 9 I posted about earlier).

 

[Marco Kalter]

I will know more by the end of this week or early next week.

 

[Marco Kalter]

We did some tests with Direct Oracle Access 4.1 on Delphi 2007, but it works fine. Have you tried this with the DeptEmp demo project?

 

[plpolak]

I tried this to reproduce:
create table test_table (test date not null);
insert into test_table values (sysdate);
commit;

Now I create a new VCL Forms application, with TOracleSession, TOracleDataSet, TDataSource and TDBGrid. SQL = select * from test_table.

Now the DBGrid shows 1 column showing 30/12/1899.

Using DOA 4.1b2, Delphi 2007 for Win32 with update 1, Oracle server 9.2.0.1 or 10.2 (XE), client 9.2.0.1 or 10.2.0.1 (all on Windows).

Pieter

 

[Marco Kalter]

We'll check it out.

 

[Marco Kalter]

Can you download and install this 4.1 version for Delphi 2007 , and let me know if the problem still occurs?

 

[plpolak]

Marco, This version seems to solve the issue. Thanks for the update.

Pieter

 

[Marco Kalter]

Great, thanks for letting me know.