TDateTime & TMyQuery
Posted: Mon 15 Nov 2004 11:07
Hi, I'm using MyDac v3.3
This is my query
SELECT
Min(SystemDate) AS MinOfSystemDate,
MonthEnd,
MonthEndProcess
FROM SystemCalendar
GROUP BY MonthEnd, MonthEndProcess
HAVING MonthEnd=1 AND SystemCalendar.MonthEndProcess=0;
The SystemDate Datatype is Date
When I attempt to assign to TDateTime variable,
datSystemDate := QMySystemDate.Fieldbyname('MinOfSystemDate').value;
it occurred error: 'Invalid variant type conversion'. How to resolve this problem? THANKS!
This is my query
SELECT
Min(SystemDate) AS MinOfSystemDate,
MonthEnd,
MonthEndProcess
FROM SystemCalendar
GROUP BY MonthEnd, MonthEndProcess
HAVING MonthEnd=1 AND SystemCalendar.MonthEndProcess=0;
The SystemDate Datatype is Date
When I attempt to assign to TDateTime variable,
datSystemDate := QMySystemDate.Fieldbyname('MinOfSystemDate').value;
it occurred error: 'Invalid variant type conversion'. How to resolve this problem? THANKS!