Great, very great, was "distinct" clause.
Very Thanks
and excuse for my bad english.
Good work all.
marco marullo

""Thomas Steinmaurer"" <ts@...> ha scritto nel messaggio
news:FGEFIGLMFAKKKHHOJFHNKEONDPAA.ts@......

> 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&h
l=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/

> >
> >
> >
>
>
>
>
> 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/
>
>
>