Subject Dates in TIBOQuery vs. PrepareSQL
Author Tony Masefield
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?