Subject | Re: Master detail relationship, Masterlinks with date type |
---|---|
Author | moczaz |
Post date | 2004-08-12T07:46:39Z |
Hello
Thank you for your detailed description, now I see the complexity of
the problem.
Thank you for your detailed description, now I see the complexity of
the problem.
--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@t...> wrote:
> Keying and linking things on dates is fraught with problems, some
soluble,
> some not. Borland software was never friendly about non-US date
formats, so
> earlier Delphi versions misbehave more than later ones. Very old
IBO
> versions simply don't recognise the ODS 10 SQLTypes. So both
Delphi and
> IBO versions might be a factor.
>
> Tell us whether you are using native TIB_ components or the
TDataset (TIBO)
> ones. It may make a difference.
I'm using TIB_components.
> And, of course, the Windows locale affects things somewhere along
the line,
> since that's the only way the error handler could have got hold of
a date
> literal in ccyy/mm/dd format.
>
> >Any ideas?
>
> The easiest thing would be to find a way to avoid using date types
as
> KeyLinks and MasterLinks.
I am working on it...
> Beyond that, with more information about the
> environment, ways and means might be found.
I'm using Delphi 6 Professional, IBO4, FireBird 1.5.0.
> Try forcing the date columns to be cast as TDate. It still won't
> necessarily solve the problem, though, because a "raw" date
portion under
> the hood in Delphi and IBO is mm/dd/ccyy, whereas, at some level,
your
> dates are being changed to ccyy/mm/dd.
What do you mean by forcing the date columns to be cast as TDate?
I think that setting up MasterLinks with date columns
(namely MasterLinks.Text:='WDATE=WDATE') causes the problem, but
I can't cast the columns here, can I?
Thanks.
Zsolt