Hi Martijn,

> > > I use a stored procedure to concat 2 fields where the second can have
> > > NULL value.
> > > But I have an Invalid request BLR at offset XXXX when I try to use a
> > > Distinct clause.
> > >
> > > For example :
> > > select distinct Q2.*,(select FIRSTLASTNAME from CONCAT_FIRSTLASTNAME
> > > (Q2.FIRSTNAME ,Q2.LASTNAME)) R_FIRSTLASTNAME
> > > from CUSTOMER Q2
> >
> > This is a known bug, DISTINCT on sub-select in select list.
>
> If this worked in Fb 1.0, but doesn't in 1.5, will it be fixed
> in 1.5.1 - as this bug makes upgrading tougher.

Read original message again, special this part :

> DISTINCT clause don't work with stored procedure (It work fine without it)

!

> Firebird 1.5 work fine but not firebird 1.0X !
>
>
> How can I do without using Firebird 1.5 ?

^^^^^^ ^^^^
:-D

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81