Subject | Re: [ib-support] Distinct with stored procedure |
---|---|
Author | Ivan Prenosil |
Post date | 2002-12-06T11:10:30Z |
> From: Ajay <ajayb@...>procedure in the Select it returns an Error .
> I am using a Select statement with a Distinct Clause, the query works fine but when i use a stored
> For EgIt is known (and old) bug.
> Select Distinct ID,First_Name,(Select Cont From GetIDs)
> From Contacts
>
> Error :- Invalid request BLR at offset 303
> context already in use (BLR error)
You can't mix DISTINCT and Subquery in SELECT clause.
Ivan
http://www.volny.cz/iprenosil/interbase