Hi,

> I am getting "BLR Error" on following query, what might be wrong?

> SELECT distinct
> Pere.FKOOD,
> Pere.PKOOD,
> Pere.PFKOOD,
> Pere.PNIMI,
> (select first 1 pildiid from perepilt where perepilt.fkood=pere.fkood
> and perepilt.pfkood=pere.pfkood and perepilt.pkood=pere.pkood) PILDIID

<snip>

You're using FB1.0 right?, but does the error-message not say more?

I guess you've "context already in use" error and there's a limit that
DISTINCT and a sub-select don't work together. This is fixed in FB1.5

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird links :
http://www.firebirdsql.com
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/


Nederlandse firebird nieuwsgroep :
news://80.126.130.81