Treety_Patnaik
asked on
filter expression
Hi all,
i have written a filter expression but i am getting a error as
"Expecting True/False Expression"
please check my expression
IF dw_2.rowcount() > 0 THEN
dw_2.setFilter("document_n o like '"+ upper(ls_doc) +"' or document_no like '"+ lower(ls_doc) +"'")
dw_2.filter()
END IF
i have written a filter expression but i am getting a error as
"Expecting True/False Expression"
please check my expression
IF dw_2.rowcount() > 0 THEN
dw_2.setFilter("document_n
dw_2.filter()
END IF
sorry try this
IF dw_2.rowcount() > 0 THEN
dw_2.setFilter("document_n o like '"+ upper(ls_doc) +" or document_no like "+ lower(ls_doc) +"'")
dw_2.filter()
END IF
IF dw_2.rowcount() > 0 THEN
dw_2.setFilter("document_n
dw_2.filter()
END IF
ASKER
it is totally not working ............. my expression is giving me the correct result but it is showing that message .....
But shru your expression is giving me no result .... the dw_2 is getting blank.
But shru your expression is giving me no result .... the dw_2 is getting blank.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect answer by Shru
dw_2.setFilter("document_n
dw_2.filter()
END IF
triy this