topic Re: Select Query not working properly in Application Development and Automation Discussions

Select Query not working properly

Former Member — Tue, 24 Apr 2012 17:22:38 GMT

Hi ,

I am using below Select query getting records from table where more then one column is space.But it is not getting any records from the table.

select * from ztab1

into table lt_im

FOR ALL ENTRIES IN lt_im

WHERE col1 = lt_im-col1

AND col2 = lt_im-col2

AND col3 = ' '

AND col4 = ' '

AND col5 = ' '.

If I use col3 <> ' '

col4 <> ' '

then it get records meeting above criterion.

Any help appericiated

Thanks,

Rek.

Former Member — Tue, 24 Apr 2012 18:54:40 GMT

The SELECT statement is working perfectly.

Press F1 on FOR ALL ENTRIES and you'll see that it eliminates duplicates from the returned set.

Rob

Former Member — Tue, 24 Apr 2012 21:12:44 GMT

Hi Rob,

Thanks for response.I found the real cause.Since col5 is date type query is failing for Col5 = ' '.

Thanks,Rek.