Rodrigo,

You'll need to give use some sample data as well as some more metadata
information, in order for us to help you.

Also, what version of Firebird/Interbase are you using?


Sean

> -----Original Message-----
> From: Rodrigo Garcia Lima [mailto:rodrigogarcia@...]
> Sent: Monday, December 10, 2001 5:28 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] BUG, I Think
>
>
> Friends,
>
> I´m trying to do this:
>
> select
> (F.CAMPO || F.CONDICAO || F.PARAMETRO || F.FINAL) AS FI from
> FILTROS F
> where
> F.CODIGO_FILTRO_MESTRE = :CODIGO_FILTRO_MESTRE
> order by
> F.CODIGO_FILTRO
>
> My table has two records, and the result most be:
>
> CODIGO_BAIRROdiferente de12E
> CODIGO_BAIRROdiferente de 11
>
> But is:
>
> CODIGO_BAIRROdiferente de12E
>
> Where's then other record?
>
> Thanks,
>
> Rodrigo Garcia Lima
> Brazil-Ceará-Fortaleza
>
>
> [Non-text portions of this message have been removed]
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Stop Smoking Now
> Nicotrol will help
> http://us.click.yahoo.com/2vN8tD/_pSDAA/ySSFAA/dpFolB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/