Dynamic SQL WHERE conditions

[Former Member]

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!

[Former Member]

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]

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

[Former Member]

ups.. I'm sorry.