>Hello fellow viewers,
>
>I would like to include a numeric field in a view filter.
>
>However, when I do, and then bind that view to a query-by-example form, the numeric field cannot be null. This works fine as long as the user uses the numeric value to do the lookup, but what if he doesn't?
>
>If I set the .value of the field to "", I get a data type mismatch.
>
>Has anyone done this successfully? If so, how?
I do it this way:
My view filter is like this: nId>=?PKVALUE_MIN AND nID<=?PKVALUE_MAX.
When I want all records I set PKVALUE_MIN to the lowest possible number and PKVALUE_MAX to the highest possible number. If I want to have just one value, I set PKVALUE_MIN and PKVALUE_MAX to the that value.
>TIA,
>Dan
hth,
Frank Camp