Problem is we are storeing the database table(pt_mstr) field name in a local variable l (ex pt_prod_line) and that database field value in another local variable k(the value of pt_prod_line as 9955) ... now there is an item whose item code(pt_part) is "xx01" ... now we have to check for that pt_part whether the product line value is 9955 or not .. by using l and k only ... so help me in this regard ...
define var l as char.
def var k as char.
l = "pt_prod_line".
k = "9955".
for first pt_mstr
where pt_part = "xx01" and l = k:
message "work".
end.
But this code is not working ... bcoz it is not considering l as database field though it contains the database field name .. but progress consider it as a text value ...
so how can we consider that as databse field....
define var l as char.
def var k as char.
l = "pt_prod_line".
k = "9955".
for first pt_mstr
where pt_part = "xx01" and l = k:
message "work".
end.
But this code is not working ... bcoz it is not considering l as database field though it contains the database field name .. but progress consider it as a text value ...
so how can we consider that as databse field....