‎2008 Jul 22 7:00 AM
hi
is it possible to use clear statement with where clause
thanks
‎2008 Jul 22 7:01 AM
‎2008 Jul 22 7:02 AM
Hi,
No it is not possible.
Do one thing before writing the clear statement write an IF condition. If your IF condition satisfies then only clear your variables or work areas or internal tables.
Thanks,
chandra.
‎2008 Jul 22 7:03 AM
hi,
it is not possible in WHERE clause to the best of ny knowledge.
But you can check a condition with IF statement and Use CLEAR statement.
Regards
Sumit AGarwal
‎2008 Jul 22 7:08 AM
‎2008 Jul 22 7:09 AM
‎2008 Jul 22 7:11 AM
Hi,
you can also do like this.
u can write check condition. then clear.
if we use check condition then the next line will be executed only if the check statement satisfies.