Hi,

At September 10, 2003, 14:24, Florian Hector wrote:

> Daniel,

> This is true and I have changed it. Thanks.
> But what I meant was the subquery for the 3rd field.
> As so often, the sparking idea comes to mind right after one hits the send button.
> Instead of the subselect I now use a second join. With this, distinct cause the error.

The bug was fixed in FB 1.5:
* Fixed unregistered bug.
"Context already in use" error in the case of DISTINCT with
sub-selects.

Also, make sure that the subquery only returns one row, otherwise
you'll get an error.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)