topic Re: Problem in Dynamic Where clause.. in Application Development and Automation Discussions

Problem in Dynamic Where clause..

Former Member — Thu, 31 May 2007 19:43:27 GMT

Hello All,

I have a requirement in which i have to do a select statement where (Field1 = 'X') and (Field2 = 'A' or Field2 = 'B').

But if i write it directly,

select * from Ztable into table itab where Field1 = 'X' and Field2 = 'A' or Field2 = 'B'.

Then I am not getting the expected result.

instead i need something which tells the where clause to do OR operation first and then AND operation..

Any ideas ??

Thanks in advance.

Tatvagna Shah.

Former Member — Thu, 31 May 2007 19:46:08 GMT

Hi,

Please try this.


select * 
from Ztable 
into table itab 
where Field1 = 'X' and ( Field2 = 'A' or Field2 = 'B' ).

Regards,

Ferry Lianto

Former Member — Thu, 31 May 2007 20:02:58 GMT

Hi,

Actually...just got a hint at almost the same time you answered...!!

Still 10 points for you....Just coz, you were the only one to reply.

Thanks.

Tatvagna.

Former Member — Fri, 04 Apr 2008 16:46:55 GMT

Also, you must remember that parentheses and operators are keywords, and must therefore be preceded and followed by at least one space.