Subject | Dates in TIBOQuery vs. PrepareSQL |
---|---|
Author | Tony Masefield |
Post date | 2005-10-12T12:25:19Z |
Hi All,
Somewhat confused. If I enter:
Where (Reading_Time > (Cast('2005/10/05' As Date)))
into a TIBO Query then I get the anticipated result.
However if I add:
SQLWhereItems.Add('(Reading_Time > (Cast('2005/10/05' As Date)))');
to the same query OnPrepareSQL I get the message:
[Error] DM_Unit.pas(74): Incompatible types: 'String' and 'Extended'
BTW, I'm using Delphi 5 Pro.
Any suggestions or references to handling dates with TIBO?
Regards,
Somewhat confused. If I enter:
Where (Reading_Time > (Cast('2005/10/05' As Date)))
into a TIBO Query then I get the anticipated result.
However if I add:
SQLWhereItems.Add('(Reading_Time > (Cast('2005/10/05' As Date)))');
to the same query OnPrepareSQL I get the message:
[Error] DM_Unit.pas(74): Incompatible types: 'String' and 'Extended'
BTW, I'm using Delphi 5 Pro.
Any suggestions or references to handling dates with TIBO?
Regards,