I have a rather tricky problem. I don't want to use SQL, but I want the result of a function to evaluate as true or false.
The user picks a fieldname from a list, then an operator (=,<>,>=,<=), then types in the answer required. I want to evaluate the concatenation of the above to a Boolean result.
I think I would need to make the whole expression into a string because I will need to use the As operator when I get the fieldtype from the field, and then cast the typed in criteria to the correct type.
I don't want to type multiple lines to cater for every possible combination of results, so I need an Eval(String) type of function.
Any help gratefully received. I am using D1.