Dear All,
i got a problem with dynamic select statement.i.e i written a select statement in that i included a where condition.the code for the where condition is as fallows.
DATA : STR_LINE TYPE EDPLINE,
STR_WHERE TYPE TABLE OF EDPLINE.
AND in STR_LINE i appended the condition values like as fallows
" industry = 'telecom' and apparea = 'r/3' and ....."
like above i've total 8 values. So Based on my requirement i may give all the 8 values or some of them.
my problem is iam able to get the where condition upto 72 char only ,cause edpline holds only 72 chars.So after i got the values into str_line iam appending that value into STR_WHERE,but when i used STR_WHERE condition in select statement it gives a dump error like in correct format of where condition.
And i tried STR_LINE type as STRING and also STR_WHERE as String and at that time also iam getting same kind of error.
MY WHERE CONDITION HOLDS APPROX., OF 200 CHAR OF LENGTH pls remeber this .
can u people pls give the solution for this,
Thanks in advance to u all,
Ajay Kumar K,
9908979994.