Marco,
I think there are two things going on here
1. the date
2. you can't read table.

1. The date is not invalid so thre is no reason why FB should rejec it
2. if you can't read it it's not becuase it's -700000, so let's discover why
you can't read it. It says invalid data conversion
are you getting this error when you select datefield from table?
Alan
-----Original Message-----
From: mk_delphi [mailto:mk_delphi@...]
Sent: Tuesday, 17 September 2002 2:50
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Panic with Date....


...but I am not able to read the data!
Also IBConsole are not able, how to
recover my gdb?
Thx
Best regards..

--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> At 03:24 PM 16-09-02 +0000, you wrote:
> >I write -700000 for my error!!
> >but why FB will accept this date?
>
> Because it stores dates as numbers and Delphi's AsDateTime
> method calculates by numbers. -700000 is simply 700000 days
before date
> zero so, in your case, I guess Delphi passed it the number it
calculated
> for the date that was midnight 30 December 1899 minus 700000 days.
Delphi
> and IB don't use the same date as date 0, btw. I think InterBase
dates
> start going negative at 18 November 1858.
>
> heLen


Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]