topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Mon, 22 Sep 2008 08:23:26 GMT

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!!!)

Re: Select Query

Former Member — Mon, 22 Sep 2008 08:30:36 GMT

Hi Neha,

You have to mention all the fileds in where condition. there is no other way.

Re: Select Query

naveen_inuganti2 — Mon, 22 Sep 2008 08:30:59 GMT

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

Re: Select Query

Former Member — Mon, 09 Mar 2009 07:45:32 GMT

I used Field Symobols for this...