10-09-2007 6:09 PM
Hi All,
I am using the following query, zzglvstid and zzglvrole are primary keys for the table zfi_glv_notf.
Data: w_test_name type tdname-zfi_glv_notf
SELECT tdname FROM zfi_glv_notf
INTO w_text_name
WHERE zzglvstid = w_group_status
AND zzglvrole = w_role.
ENDSELECT.
When I do and extended program check it says " SELECT TDNAME HAS AN EMPTY BODY", I don't why.
Can any one help me in getting it through ...(do not want to use "#EC *)
Thanks
10-09-2007 6:22 PM
Hi ram,
is not
Data: w_test_name type zfi_glv_notf-tdname.
???
how this table is declarated??
Regards
Allan Cristian
10-09-2007 6:32 PM
From your SELECT it feels that TDNAME is a structure whose value you are trying to pass to a variable W_TEST_NAME. Please make correction in W_TEST_NAME declaration and it should solve your problem.
ashish
10-09-2007 6:38 PM
Hi
First corrrect the DATA decleration...
it should be like <b>tablename - field name</b>
<b>Data: w_test_name type zfi_glv_notf-tdname</b>
SELECT tdname FROM zfi_glv_notf
INTO w_text_name
WHERE zzglvstid = w_group_status
AND zzglvrole = w_role.
ENDSELECT.
<b>Reward Points if it is helpful.</b>
Thanks & Regards
ilesh 24x7
10-09-2007 6:54 PM
Why is there no code between your
SELECT tdname FROM zfi_glv_notf
INTO w_text_name
WHERE zzglvstid = w_group_status
AND zzglvrole = w_role.
<b>*Code ????</b>
ENDSELECT.
11-17-2009 4:39 PM
If you're not selecting into a table, you don't need the ENDSELECT statement, but your select statement should be SELECT SINGLE
11-17-2009 5:07 PM
Hi Ram ,
It means that body of SELECT and ENDSELECT is empty, you should have written some logic here.
Check your program again , you can replace it by SELECT or SELECT SINGLE.
11-17-2009 5:11 PM