Subject Re: [ib-support] Distinct with stored procedure
Author Ajay
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.

----- Original Message -----
From: Milan Babuskov
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

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

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

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