>>>>You can open your view with NODATA clause - and then it won't ask for parameters until the first requery(), which can happen much later in code.
>>>
>>>Hi Dragan,
>>>
>>>I find that there's an exception to that.
>>>
>>>Have you ever put a ?parameter in the join clause ? It will ask for a parameter when opened with NODATA
>>
>>Try NOREQUERY as well. Not sure what it does, and the view I tried it on pulls from other parametrized views, so I'm not sure whether the ?parameter was in the join or in the where only. It's sort of hard to dig out on a sunny Saturday when I'm doing my taxes :).
>
>The same behaviour with NODATA NOREQUERY. You'll see after the taxes...
OK, a simpler workaround. Supply dummy impossible parameters before opening it, some combination which will return zero records.