Thx Alan,
Yes I have fixed, but I dont figure out..
The control is dxDBDate from DevExpress
if U insert an invalid date the control
turn it as blank, and the .date value
is -700000...
thanks for your suppor,
here (in italy) is 7:30 p.m. is the time
to go to my home......(my wife is not so
friendly like ib-support's girls)
Ciao Alan.

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