I´ve another computer with firebird beta 4 installed and my original command
works fine and quickly. I think to be a bug at version 1.0 or not?

Thank you very much for help.

> ----- Mensagem original -----
> De: Arno Brinkman [SMTP:firebird@...]
> Enviada em: segunda-feira, 7 de abril de 2003 16:49
> Para: ib-support@yahoogroups.com
> Assunto: Re: [ib-support] firebird client crash with select
>
> Hi,
>
> > the correct syntax is:
> >
> > SELECT
> > r.cod_hermes,
> > r.nom_rev
> > FROM
> > revendedora r
> > WHERE
> > EXISTS(SELECT r1.cod_hermes FROM revendedora r1
> > WHERE r1.cod_hermes = r.cod_hermes
> > group by r1.cod_hermes
> > HAVING count(*) > 1)
> > order by 1
>
> Well the asterisk was indeed wrong!
> You can use also a constant instead, what you want ;-)
>
> SELECT
> r.cod_hermes,
> r.nom_rev
> FROM
> revendedora r
> WHERE
> EXISTS(SELECT 1 FROM revendedora r1
> WHERE r1.cod_hermes = r.cod_hermes
> HAVING count(*) > 1)
> ORDER BY 1
>
> Regards,
> Arno
>
>
>
> 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/
>