Select Cont From GetIDs is the stored procedure and i am passing a parameter to it. It returns a single row.i am using a select because it is a stored procedure.

Ajay.

----- Original Message -----
From: Milan Babuskov
To: ib-support@yahoogroups.com
Sent: Thursday, December 05, 2002 9:21 PM
Subject: Re: [ib-support] Distinct with stored procedure


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



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]