Matthias Juchem wrote :

>In 7.3.0.25, is it not possible to use parameters in subquery of EXISTS?

>Like
> IF EXISTS ( SELECT * FROM
>  user1.table1 t1
>  WHERE t1.key = :somevariable )
> THEN
> ...

Sorry, but it was never intended to support EXIST or ANY predicate 
in the IF/WHILE statement. This means, that your code will not work correctly, 
even without parameter.
Unfortunately the parser compiles that code without any error. This will be 
changed in one of the next releases.

Regards,
Thomas 

-- 
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to