--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:

>
> > --- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...>

wrote:

> > >
> > > > 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)))');
> > >
> > Thanks for the reply Alan.
> > Have tried your suggestion. The program compiles and starts

running

> > but then get the message "Column Unknown 2005/10/05" from IBO.
> > Any more suggestions?
> > Suppose I should add that the Reading_Time field is a Timestamp

but

> > read somewhere that the Date/Timestamp conversions are "OK" so

doubt

> > that is the problem (anyway it runs in the SQL for the query OK).
>
> you would get "column unknown" if you put double quotes around the

date - I

> want you to put 2 single quotes.
> i.e. NOT "
> but ''
>
> Alan
>

Thanks Alan, missed the two single apostophes vs. the double
apostrophe. Now working fine. This construct is a little peculiar
(at least to me).
Thanks for the help.
Tony

> > >
> > > > 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
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> >

__________________________________________________________________

> > _________
> > 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
>