Subject Re: [ib-support] Distinct with stored procedure
Author Milan Babuskov
Ajay wrote:
> I am using a Select statement with a Distinct Clause, the
> query works fine but when i use a stored procedure in the Select it
> returns an Error . For Eg Select Distinct
> ID,First_Name,(Select Cont From GetIDs) From Contacts
>
> Error :- Invalid request BLR at offset 303
> context already in use (BLR error)

Which of these is a Stored Procedure?, GetIDs I presume?
Why do you do Select Cont from GetIDs? Does GetIDs return only one row?
How does GetIDs look like?

More questions than answers...

Milan Babuskov
http://sourceforge.net/projects/fbexport