topic Re: Dynamic SQL WHERE conditions in Application Development and Automation Discussions

Dynamic SQL WHERE conditions

Former Member — Tue, 26 Sep 2017 09:20:13 GMT

Hi,

I want to use a dynamic select statement like:

SELECT * FROM XYZ WHERE (ls_query_where_cond) INTO....

This woorks fine but I do not always have a where condition. This will raise a exception.

Can I completely remove this "where" dynamicly or do I have to use if statements to check if there any "where" condition before execution?

Thanks!

RaymondGiuseppi — Tue, 26 Sep 2017 09:26:54 GMT

Did you read the online or F1 documentation on sql_cond - (cond_syntax)... look for 'If cond_syntax is initial'.

Former Member — Tue, 26 Sep 2017 09:42:32 GMT

ups.. I'm sorry.