Helen,

Thank you very much, this works. However, can you please litle
explain why I have to remove DISTINCT from query, since I have rows
which I would like to remove with DISTINCT command. Is there any
other solution ???

Regards,

Zoran Zivkovic


--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 11:45 AM 9/05/2005 +0000, Zoran Zivkovic wrote:
> >Helen,
> >
> > I need some more help. I am receiving folowing error:
> >
> >Invalid token.
> >invalid request BLR at offset 186.
> >context already in use (BLR error).
> >
> >when i try to execute folowing query:
> >
> >SELECT DISTINCT PARTNO
> > , EAPARTNO
> > , FILTER_TYPE
> > , COMMENT
> > , CAST ((CENOVNIK.SP*(SELECT KP1.KURS from KURS_POREZ KP1)*
> >(SELECT 1+(KP2.POREZ/100) FROM KURS_POREZ KP2) /1.00) AS DECIMAL
> >(15,2)) AS MPC
> >FROM FILTER_PARTS
> >JOIN CENOVNIK ON (FILTER_PARTS.EAPARTNO=CENOVNIK.EAPARTNO)
> >
> >Structure of table FILTER_PARTS is
> >
> >CREATE TABLE FILTER_PARTS (
> > APPL_ID INTEGER NOT NULL,
> > PARTNO VARCHAR(10) NOT NULL,
> > EAPARTNO VARCHAR(11) NOT NULL,
> > FILTER_TYPE VARCHAR(16),
> > COMMENT VARCHAR(19),
> > DETAIL_SEQ INTEGER
> >);
> >
> >Can you please advice what this could be ???
>
> Take out the DISTINCT and fix up your table identifiers (see my

original

> suggestion.)
>
>
> > > SELECT
> > > wpp.PARTNO
> > > , wpp.EAPARTNO
> > > , wpp.DESCRIPTION
> > > , wpp.PART_OE AS OE /* why? */
> > > , CAST ((c.SP * kp.KURS * kp.POREZ/1.00) AS DECIMAL

(15,2))

> >AS MPC
> > >
> > > CAST ((c.SP * (select kp1.KURS from KURS_POREZ kp1)
> > > * (SELECT kp2.POREZ from KURS_POREZ kp2) /1.00) AS DECIMAL
> >(15,2)) AS MPC
> > > FROM WATER_PUMPS_PARTS wpp
> > > LEFT JOIN CENOVNIK c
> > > ON wpp.EAPARTNO=c.EAPARTNO
> > >
> > >
> > > More elegant and speedy would be a selectable stored proc that
> >reads the
> > > KURS_POREZ record only once, into variables.
> > >
> > > ./hb