>>I have a parameterized view with two view parameters. One parameter is a string, the other an integer. I'd like to be able to select all records in the view, but when I leave the integer view parameter blank I get a "data type mismatch" error. Obviously, this is because the empty vp is being converted to a string. How do I make the view so that I don't have to put a value in the integer view parameter?
>
>What about converting the single integer view parameter into two integers that form a range search:
>
>WHERE column = ?vp_integer
>
>becomes
>
>WHERE column BETWEEN ?vp_integer1 AND ?vp_integer2.
>
>If you want to find a specific value set vp_integer1 = vp_integer2 = value
>To ignore the integer view parameter set vp_integer1 to something very small and vp_integer2 to something very large.
>
>-Mike

If you're using the view designer, define the parameter as an Integer using Query | View Parameters from the menu.