Hi,

I have this query:

INSERT INTO
szamlaegyenlegek(szamlaszam, halmt, halmk, halme, uzleti_ev, alperiodus_kod, datum, targyt, targyk, targye, kpnem)
SELECT DISTINCT
szamlaegyenlegek.szamlaszam,
first_value(halmt) OVER (PARTITION BY szamlaegyenlegek.szamlaszam ORDER
BY datum DESC, alperiodus_kod DESC),
first_value(halmk) OVER (PARTITION BY szamlaegyenlegek.szamlaszam ORDER BY datum DESC, alperiodus_kod DESC),
first_value(halme) OVER (PARTITION BY szamlaegyenlegek.szamlaszam ORDER BY datum DESC, alperiodus_kod DESC),
'2013' AS uzleti_ev, 0 AS alperiodus_kod, DATE '2014.01.01' AS datum, 0, 0, 0, 'HUF' AS kpnem
FROM szamlaegyenlegek INNER JOIN szamlatukor ON szamlaegyenlegek.szamlaszam=szamlatukor.szamlaszam
WHERE szamlatip IN ('Akt�v', 'Passz�v') AND uzleti_ev='2013' AND datum<='2013.12.31'

I have installed firebird 2.5.2 on my machine (win 7 x64)

And I get this error, if I try to run the query:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 4, column 54.
(.

It should work, because firebird 2.5.2 should know the over partition function.

What is wrong?

Thanks.

[Non-text portions of this message have been removed]