![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Sat, Nov 8 2008 10:10 AM | Permanent Link |
"KHJ" | 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 |
Sun, Nov 9 2008 7:56 PM | Permanent Link |
Fernando Dias ![]() | 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] |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |