Subject | Re: [ib-support] Distinct with stored procedure |
---|---|
Author | Milan Babuskov |
Post date | 2002-12-05T15:51:18Z |
Ajay wrote:
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
> I am using a Select statement with a Distinct Clause, theWhich of these is a Stored Procedure?, GetIDs I presume?
> 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)
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