Andrew,

Thank you but TIB_Query (and TIBOQuery) returns error message: expression
evaluation not supported.
Isc Error Code: 335544606
In IBX run ok!
What´s wrong in IBObjects?
Thanks.

Pedro Sergio Angelotti
Pontosoft Informática S/C Ltda.
http://www.pontosoft.com.br/

----- Original Message -----
From: "Andrew" <ahaines@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, September 13, 2004 5:39 PM
Subject: Re: [IBO] Select customers from month of birthday


> psangelotti2 wrote:
>
> >Hi all,
> > I am trying to select the customers born in one determined month and
> >I am not obtaining.
> >The syntax that I am using is the following one:
> >select name, dtnasc, telephone
> > from customers where month(dtnasc) = 9
> > order by dtnasc
> >I also tried: where month(dtnasc) = '9' and where month(dtnasc)
> >= 'AUG'
> >
> >
> Try this, it's from memory and not tested:
>
> select name, dtnasc, telephone
> from customers
> where
> extract(month from dtnasc)=9
> order by dtnasc
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
___________________________________________________________________________
> 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
>
>
>
>
>
>