09-22-2008 9:23 AM
Hi all,
i need to fetch data from table T334E, where Primary keys are LGNUM and LGTYP and the other fields in the table are like LETY0,LETY1..........LET29.
i need to apply the condition something like....
select.....
from t334e
into.....
where lgnum = 'WZ1'
and lgtyp = <input lgtyp>
and LET&& = <input letyp>.
so my ques is how can i achieve this , is there any other way by which i can check whether LETY0...to....LET29, any of these fields holds the <inpu letyp>,otherwise i need to write those many conditions in the where clause as the no of fields LET&& (30!!!)
09-22-2008 9:30 AM
Hi Neha,
You have to mention all the fileds in where condition. there is no other way.
09-22-2008 9:30 AM
Hi Neha,
You have to mention all the fileds in where condition. there is no other way.
09-22-2008 9:30 AM
Hi..,
You have to declare ONE select-option for that filed,
And..,
Need to write where condition with all fields by checking with same select-options table.
Even if you try to write dynamic select-query for this, it reuires code more than this, as you need to check reuired variable anyway!
Thanks,
Naveen.I
03-09-2009 7:45 AM