Stephen ---

The way to avoid an error, when using a Form is to set the NoDataOnLoad property for the view to true and then =REQUERY() in, say, the Init of the form. From the Command Window, you shouldn't get an error; it should just prompt you for the value of vp_CustNo.


>John I had that part, I wanted to know how to store the parameter in the view so It would be prompted for when I issue :
>
>use ves!lv_CustOrders
>
>This way I don't get an error in initial seting up or testing. The parameter is poplulated via the selection of another view so in ram vp_CustNo is defined.
>
>When you are in the view builder you would drop down the Query and get View parameters. This is where I would defind vp_CustNo as character. Can this be done via code so I can populate my dbc myself?
>
>Thanks for your input.
>
>>Hi Stephen ---
>>
>>>How to define a view that is created via a union and use it?
>>>
>>>I have a table of sales orders (shipped) and SO (open). I have unioned the 2 together and I want a vp_CustNo as a parameter. How do I code that in the Create SQL View command?
>>>
>>

>>CREATE SQL VIEW vue_orders AS ;
>>   SELECT * FROM shipped WHERE custno = ?vp_custno ;
>>   UNION ;
>>   SELECT * FROM salesopen WHERE custno = ?vp_custno

>>
>>>This parameter is going to be populated by user selecting a customer from a view off the first page. The # of pages on this form set is growing daily. It's a customer support system and the wish list is growing way to fast.
>>>
>>>Any reasons not to do a 6 page formset in MM & CB?
>>>
>>>__Stephen Russell
>>>Memphis FPUG