Select Statement error?

[Former Member]

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

[Sm1tje]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

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

reward if helpful

raam

[Former Member]

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