On Mon, 29 Mar 2004 19:12:35 +0000 (UTC), Raigo wrote:

> I am having a strange problem with date field - when a value is not
> entered, somehow into that field is inserted 30.12.1899.
> When I enter value, everything is correct.
>
> I am using Firebird 1.0.3. when I create the field I use
> alter table myTable add myField DATE ;
>
> when I look at it in Delphi's SQL Explorer I see TIMESTAMP.

Don't use the "value" if the field is Null!
If zero is returned from your 'middleware', it will show as 30.12.1899.


--
Aage J.