I want to create a view with the following SQL

SELECT kc.kc_id, kc.kc_bez1d, kc.kc_bez1e, kc.kc_festigkeit,
kc.kc_kc11, kc.kc_mc, quelle.quelle_titel, methode.methode_bez_d
FROM kc, quelle, methode
WHERE ((kc.kc_quelle_id = quelle.quelle_id) and(kc.kc_methode_id =
methode.methode_id))
and (UPPER(kc.kc_bez1d)LIKE UPPER(:bez1d))
and (UPPER(kc.kc_bez1e)LIKE UPPER(:bez1e))
and (UPPER(quelle.quelle_titel)LIKE UPPER(:quelletitel))
and (UPPER(methode.methode_bez_d)LIKE UPPER(:methodebezd))
ORDER BY kc.kc_bez1d

But I get the error dynamic parameter references not allowed.
Is there something wrong or is it not possible to use the :bez1d,
:bez1e, :quelletitel and :methodebezd?

Karlheinz

Karlheinz,

If you need to use parameters, then you should use a stored procedure
instead of a view. Also, you should update the syntax of your joins
because this old SQL-89 joins are not optimized by EDB. In this case you
should replace them with INNER JOINs .

--
Fernando Dias
[Team Elevate]