Subject | Master detail relationship, Masterlinks with date type |
---|---|
Author | moczaz |
Post date | 2004-08-11T21:27:30Z |
Hello
I've got a problem with a master detail relationship, where
the master dataset is:
SELECT DISTINCT WDATE FROM WAYBILLS;
the detail dataset is :
SELECT E.NAME, C.TYPE, C.PLATE , W.WDATE,
FROM EMPLOYEES E, CARS C, WAYBILLS ');
WHERE M.ALKID=A.ID AND M.RENDSZAM=J.RENDSZAM');
and the most important thing(I guess): the Masterlinks property is:
WDATE=WDATE
I get the following error message with the settings above:
EConvertError, '2003/07/29 00:00:00.0000 is not a valid date and
time'
I find it strange because the error message looks like as if I was
working with timestamps and I used an invalid one, but I have
nothing to do with timestamps but simple dates.
Any ideas?
I've got a problem with a master detail relationship, where
the master dataset is:
SELECT DISTINCT WDATE FROM WAYBILLS;
the detail dataset is :
SELECT E.NAME, C.TYPE, C.PLATE , W.WDATE,
FROM EMPLOYEES E, CARS C, WAYBILLS ');
WHERE M.ALKID=A.ID AND M.RENDSZAM=J.RENDSZAM');
and the most important thing(I guess): the Masterlinks property is:
WDATE=WDATE
I get the following error message with the settings above:
EConvertError, '2003/07/29 00:00:00.0000 is not a valid date and
time'
I find it strange because the error message looks like as if I was
working with timestamps and I used an invalid one, but I have
nothing to do with timestamps but simple dates.
Any ideas?