Hi,
i have a strange problem with this query

SELECT filedati.idx, suoni.idx, suoni.nome AS nomeSuono, suoni.dimens,
suoni.descriz, suoni.idTipoSuono, suoni.sampleHz, lksuoni.idSuono,
lksuoni.idFile, lksuoni.posSuono, tiposuono.nome AS descTipo FROM filedati,
suoni, lksuoni, tiposuono
WHERE lksuoni.idSuono = suoni.idx
AND suoni.idTipoSuono = tiposuono.idx
AND (lksuoni.idFile = filedati.idx OR :Pidx = 0)
AND lksuoni.idFile = :Pidx
ORDER BY lksuoni.posSuono

If execute query:
Pidx != 0  -->OK
Pidx = 0  -->Hangs

If i try in ElevateDB Manager:
Pidx != 0  -->OK
Pidx = 0  -->OK

Any suggestion?

thanks

<< i have a strange problem with this query >>

It's either one of two things.  There is an issue with 1.06 in terms of
parameterized queries that return an insensitive result set not completing
due to the change detection constantly kicking in.  The other issue is that
your query is using SQL-89 joins, which EDB does not optimize.  You should
use SQL-92 joins instead with the INNER JOIN statement.

--
Tim Young
Elevate Software
www.elevatesoft.com