>I have this query with some parameters:
>
>"INSERT INTO " & _
> "szamlaegyenlegek(szamlaszam, halmt, halmk, halme, uzleti_ev, alperiodus_kod, datum, targyt, targyk, targye, kpnem) " & _
> "SELECT DISTINCT " & _
> "szamlaegyenlegek.szamlaszam, (select max(halmt) from (select halmt from szamlaegyenlegek where uzleti_ev=@elozofoper and datum<=@elozovege)), " & _
> "(select max(halmk) from (select halmk from szamlaegyenlegek where uzleti_ev=@elozofoper and datum<=@elozovege)), " & _
> "(select max(halme) from (select halme from szamlaegyenlegek where uzleti_ev=@elozofoper and datum<=@elozovege)), " & _
> "@kovuzlev AS uzleti_ev, 0 AS alperiodus_kod, DATE @kovuzlev_kezdes AS datum, " & _
> "0, " & _
> "0, " & _
> "0, '" & KPNEM & "' AS kpnem " & _
> "FROM szamlaegyenlegek INNER JOIN szamlatukor ON szamlaegyenlegek.szamlaszam=szamlatukor.szamlaszam " & _
> "WHERE szamlatip IN ('Aktív', 'Passzív') AND szamlaegyenlegek.szamlaszam=@szamlaszam and uzleti_ev=@elozofoper AND datum<=@elozovege"
>
>If I run the query, I get the error:
>
>Dynamic SQL Error SQL error code = -104 Token unknown - line 1, column 497 ?
>
>The column 497 is at @elozofoper and datum<=@elozovege)), @kovuzlev AS uzleti_ev.
>
>As you see, all the parameters have a value:
>
>FirebirdSql.Data.FirebirdClient Information: 0 : Parameters:
>
>FirebirdSql.Data.FirebirdClient Information: 0 : Name:@kovuzlev Type:VarChar Used Value:2014
>FirebirdSql.Data.FirebirdClient Information: 0 : Name:@kovuzlev_kezdes Type:TimeStamp Used Value:01/01/2014 00:00:00
>FirebirdSql.Data.FirebirdClient Information: 0 : Name:@elozofoper Type:VarChar Used Value:2013
>FirebirdSql.Data.FirebirdClient Information: 0 : Name:@elozovege Type:VarChar Used Value:2013.12.31.
>FirebirdSql.Data.FirebirdClient Information: 0 : Name:@szamlaszam Type:VarChar Used Value:541100
>
>It is strange, why I don't get the same error f.e at one line above in the query. I have there the same parameter.

Hi Varga, here's my guess:

Helen has many times said that parameters are place holders, not variables, and that they cannot be reused. Some component sets actually let you reuse parameters with little or no problem (e.g. with IBObjects, problems only occur if the same parameter name is used for fields of different types), but it might not be the case for you. So, try changing your query to use a different name for each parameter, or change your query - e.g. to something like this:

INSERT INTO
szamlaegyenlegek(szamlaszam, halmt, halmk, halme, uzleti_ev, alperiodus_kod, datum, targyt, targyk, targye, kpnem)
WITH tmp(elozofoper, elozovege, halmt, halmk, halme) AS
(SELECT uzleti_ev, max(datum), max(halmt), max(halmk), max(halme)
FROM szamlaegyenlegek
WHERE uzleti_ev=:elozofoper
AND datum<=:elozovege)
SELECT DISTINCT se.szamlaszam, t.halmt, t.halmk, t.halme, :kovuzlev, 0, cast(:kovuzlev_kezdes as Date), 0, 0, 0, :KPNEM
FROM szamlaegyenlegek se
JOIN szamlatukor st ON se.szamlaszam=st.szamlaszam
JOIN tmp t on se.uzleti_ev = t.uzleti_ev
WHERE st.szamlatip IN ('Aktív', 'Passzív')
AND se.szamlaszam=:szamlaszam
AND se.datum<=t.elozovege

HTH,
Set