>Back in VFP 5 I tried to get both INLIST() and IN() to work with variable values and never did get to work out. Anybody else know of a way to use either of these without hardcoding the list of values they use?
Nope. I have had this problem where you can not parameterize a list of values for the IN or INLIST function. The problem is with character values where each has to be in quotes. You can not submit a character string like "3053", "3051", ..., "4152" . If you know you will never submit X number of items in the list, you could create X parameters in the IN.
IN (?Parm1, ..., ?ParmX)
Then if the user only select X-1 parameters, you would have to make parameter X some value that you must know does not exist. I have never found a way to parameterize a list with a variable number of parameters, at least for a permanent view.
You can build this successfully in SPT.
Mark McCasland
Midlothian, TX USA