so does this mean you have fixed he database?
out of interest what was the control which produced this date?
-----Original Message-----
From: mk_delphi [mailto:mk_delphi@...]
Sent: Tuesday, 17 September 2002 3:12
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Panic with Date....


Hi Alan,
When I perform a select I am able to browse
the data unless I reach the bads records,
when I get the bad records IBConsole (and others)
show me the error message 'Invalid data conversion'
and browsing stops...
The update work, so if I replace the bad DATE with nulls
I am able to navigate the table...
This solve my problem, but let me in a panic
state...
Thx
Best regards

--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> 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@y...]
> Sent: Tuesday, 17 September 2002 2:50
> To: ib-support@y...
> 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@e...
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
>
>
>
> [Non-text portions of this message have been removed]


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]