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

Oh darn ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com