Subject RE: [ib-support] Re: Panic with Date....
Author Alan McDonald
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?
-----Original Message-----
From: mk_delphi [mailto:mk_delphi@...]
Sent: Tuesday, 17 September 2002 2:50
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?
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
> for the date that was midnight 30 December 1899 minus 700000 days.
> and IB don't use the same date as date 0, btw. I think InterBase
> start going negative at 18 November 1858.
> heLen

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

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

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