I'm fairly new to progress and I need a bit of help generating a for each statement that I can dynamically change.
this is what I have so far:
<clip>
define var as int.
var = 10.
for each record where record.id = var no-lock break by record.second-id:
more code
</clip>
instead of looking for just "10" in this case I want to build the for each statement to use 'var' for the entire where block. I added a second var with an or and it worked fine, like:
"for each record where record.id = var or record.id = var2 no-lock break by record.second-id:"
but when I try and put both in a single variable it breaks.
<clip>
define var as char.
var = "record.id = 10 or record.id = 11".
for each record where var no-lock break by record.second-id:
more code
</clip>
any ideas on how to get it to work or if I should try another way.
thanks for the help?
this is what I have so far:
<clip>
define var as int.
var = 10.
for each record where record.id = var no-lock break by record.second-id:
more code
</clip>
instead of looking for just "10" in this case I want to build the for each statement to use 'var' for the entire where block. I added a second var with an or and it worked fine, like:
"for each record where record.id = var or record.id = var2 no-lock break by record.second-id:"
but when I try and put both in a single variable it breaks.
<clip>
define var as char.
var = "record.id = 10 or record.id = 11".
for each record where var no-lock break by record.second-id:
more code
</clip>
any ideas on how to get it to work or if I should try another way.
thanks for the help?