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