ok you have a parameter that has a the word all, or a range like 1-10, or just a number, like 5 in it? And you need to determine if the value in the table matches the parameter?
if this is the case, I would try something like:
local booleanvar keep := true;
local numbervar start;
local numbervar finish;
if {?parameter} <> 'ALL' then(
if instr({?parameter}, '-') > 0 then(
start := val(mid({?parameter}, 1, instr({?parameter}, '-'));
finish := val(mid({?parameter},instr({?parameter}, '-')+1);
if {numeric.field} > finish or {numeric.field} < start then keep := false;
)
else(
if val({?parameter}) <> {numeric.field} then
keep := false
)
);
keep
I think that will work...might have minor syntax issues with ;
HTH
IP Logged
