Hi,

without sitting at my development computer i've got a question from a customer.

Is there any known problem with the current beta release and date fields.

In the newest version of my program all date values are returned as the constant value "30.12.1899".

SQL*Net v9.2
Database 9.2 and 10g

Greetings and thanks
Jens

Could this possibly be caused by wrong handling of NULL values? We have had problems with a date component, which does not handle deletion of a date value correctly. Instead of changing the field value to NULL it is set to 0 - which causes the date to be interpreted as "30.12.1899".

In our case, this is not related to DOA, but to the delphi date component.

With regards,
Helene

But the only thing i have changed is the doa version. All other components are unchanged.

I did a little test with the current beta, and cannot immediately find a problem with dates. Can you create a little project to reproduce this?

I will try tomorrow.

Done

No problem here. Can you let me know the following?

1. The results of the following query:

select * from nls_database_parameters
where parameter like 'NLS%CHARACTERSET';

2. A registry export of:

HKEY_LOCAL_MACHINE\Software\Oracle

Thanks in advance.

Answered by Mail two hours ago :-)