Marco,

First, you haven't provided us with the information what
InterBase or Firebird version you are using.

Second, I recall something about this in case of using a
DISTINT and inner SELECTS.

Doing a simple Google Group search on "interbase context
already in use" will give some results.

One of them is:
http://groups.google.at/groups?q=interbase+context+already+in+use&start=20&hl=de&lr=&ie=UTF-8&oe=UTF-8&selm=38d9cfe2%40dnews&rnum=29
(watch the wrap ;-))



HTH,
Thomas Steinmaurer
IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com

> -----Original Message-----
> From: marco marullo [mailto:markmar.it@...]
> Sent: Friday, October 04, 2002 6:37 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Invalid request BLR at offset 661 context already
> in use (BLR error).
>
>
> When I open a Query in IBExpert it is all OK. In Delphi 5 he gets stuck, and
> the error message comes. Why?
> I need help!
> Thanks
> marco marullo
>
> P.S.:
>
> The query...
>
> SELECT distinct
> ANAGRA.ANAGRA_PRG,
> GRADO.GRADO_PRG,
> RUOLO.ANNO_RG,
> GRADO.UTENTE,
> GRADO.TIPO_ATTO,
> GRADO.TIPO_TRIBUNALI,
> GRADO.NM_ATTO,
> GRADO.DT_DEPOSITO,
> GRADO.DTINS,
> ANAGRA.COGNOME, ANAGRA.NOME,ANAGRA.CF, ANAGRA.USA,
> RESID_ANA.INDIRIZZO, RESID_ANA.CAP, RESID_ANA.CITTA,RESID_ANA.PROV, RESID_ANA.USA,
> LEGALE.COGNOME, LEGALE.NOME, LEGALE.CF,LEGALE.INDIRIZZO, LEGALE.CAP, LEGALE.CITTA,
> LEGALE.PROV, LEGALE.USA,(SELECT SUM(IMPOSTA.EURO) FROM IMPOSTA
> WHERE GRADO.GRADO_PRG = IMPOSTA.GRADO_PRG group by grado.grado_prg)SOMMA
> FROM LEGALE
> FULL OUTER JOIN ANAGRA ON (LEGALE.ANAGRA_PRG = ANAGRA.ANAGRA_PRG AND LEGALE.USA='V')
> FULL OUTER JOIN RESID_ANA ON (ANAGRA.ANAGRA_PRG = RESID_ANA.ANAGRA_PRG AND RESID_ANA.USA='V')
> FULL OUTER JOIN RUOLO ON (ANAGRA.RUOLO_PRG = RUOLO.RUOLO_PRG)
> FULL OUTER JOIN GRADO ON (RUOLO.RUOLO_PRG = GRADO.RUOLO_PRG)
> INNER JOIN DECISIONI ON (GRADO.TIPO_ATTO = DECISIONI.DECISIONI_PRG)
> INNER JOIN TRIBUNALI ON (GRADO.TIPO_TRIBUNALI = TRIBUNALI.TRIBUNALI_PRG)
> WHERE
> ((grado.utente=current_user)or(current_user='SYSDBA'))and
> ((((ANAGRA.USA = 'V')and(RESID_ANA.USA = 'V')and(resid_ana.dtagg>=:DTINS1 and resid_ana.dtagg<=:DTINS2))or
> ((ANAGRA.USA = 'V')and(LEGALE.USA = 'V')and(LEGALE.dtagg>=:DTINS3 and LEGALE.dtagg<=:DTINS4)))
> or(RUOLO_PRG=:RUOLO_PRG))
> order by grado.dt_deposito asc,grado.grado_prg,anagra.cognome,anagra.nome
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>