Subject Re: [firebird-support] BLR Error
Author Arno Brinkman

> 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

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

Arno Brinkman

Firebird links :

Nederlandse firebird nieuwsgroep :