> 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)))');

try
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,
>
>
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>