topic Re: Select Statement error? in Application Development and Automation Discussions

Select Statement error?

Former Member — Tue, 15 Apr 2008 09:19:15 GMT

HI friends please i need your help in select statement ...

Details i am having four input values they are EMPID, DATES, EMPNAME, REQNO

requirement is when i am entering reqno range or empid range or dates range or empname range it has to display the output.

reqno, emp_id, date, empname are my select-options name

SELECT-OPTIONS : REQ_NO FOR W_OUTPUT-REQNO MATCHCODE OBJECT ZCH7,

EMP_ID FOR W_OUTPUT-EMPID MATCHCODE OBJECT ZCH7,

DATE FOR W_OUTPUT-DATES MATCHCODE OBJECT ZCH7,

EMP_NAME FOR W_OUTPUT-EMPNAME MATCHCODE OBJECT ZCH7.

SELECT SINGLE * FROM ZRIF_SAVE WHERE REQNO = REQ_NO

AND EMPID = EMP_ID

AND DATES = DATE

AND EMPNAME = EMP_NAME.

please correct my select statement its very very urgent...

Thks

Re: Select Statement error?

Sm1tje — Tue, 15 Apr 2008 09:20:59 GMT

when using range (select options) use the IN operator instead of '='.

Re: Select Statement error?

Former Member — Tue, 15 Apr 2008 09:21:15 GMT

SELECT-OPTIONS : REQ_NO FOR W_OUTPUT-REQNO MATCHCODE OBJECT ZCH7,

EMP_ID FOR W_OUTPUT-EMPID MATCHCODE OBJECT ZCH7,

DATE FOR W_OUTPUT-DATES MATCHCODE OBJECT ZCH7,

EMP_NAME FOR W_OUTPUT-EMPNAME MATCHCODE OBJECT ZCH7.

SELECT SINGLE * FROM ZRIF_SAVE WHERE REQNO in REQ_NO

AND EMPID in EMP_ID

AND DATES in DATE

AND EMPNAME in EMP_NAME.

Re: Select Statement error?

Former Member — Tue, 15 Apr 2008 09:21:29 GMT

change the select statement as ...

SELECT SINGLE * FROM ZRIF_SAVE WHERE

REQNO IN REQ_NO

AND EMPID IN EMP_ID

AND DATES IN DATE

AND EMPNAME IN EMP_NAME.

Re: Select Statement error?

Former Member — Tue, 15 Apr 2008 09:21:40 GMT

where is INTO part ?

use :

SELECT SINGLE * FROM ZRIF_SAVE

into a, b, c,d

WHERE REQNO in REQ_NO

AND EMPID in EMP_ID

AND DATES in DATE

AND EMPNAME in EMP_NAME.

Reward points, if helpful,

sandeep kaushik

Re: Select Statement error?

Former Member — Tue, 15 Apr 2008 09:21:45 GMT

Hi,

u need to use IN instead of = operator in where condition in select statement.

reward if helpful

raam

Re: Select Statement error?

Former Member — Tue, 15 Apr 2008 09:28:40 GMT

hi,

try like dis.......

declare the tb_temp table OF TYPE table/structure ZRIF_SAVE

SELECT SINGLE *

INTO tb_temp

FROM ZRIF_SAVE WHERE REQNO in REQ_NO

AND EMPID in EMP_ID

AND DATES in DATE

AND EMPNAME in EMP_NAME.

Regards,

Padmasri.

Edited by: Padmasri on Apr 15, 2008 11:29 AM