>>
>> I have a view that uses a UNION clause. As the UNION is not supported by
>> the view builder, I cannot produce such using it.
>>
>> If I create the view with code, I am required to have exclusive access to the database.
>>
>> Does anyone know of a way to incorporate views that use clauses outside the scope of the view builder in a shared database?
>>
>> I would like this view to be a permanent part of
>> the database.
>>
>> Any help is appreciated,
>>
>> Chris
>
>Chris,
>
>I've never done this myself, by there _is_ a create sql view statement
>that does exactly what you want. To create the view (in VFP3) you need
>to open the database in exclusive mode though, but since you want this
>to be permanent, I do not see a problem.
>
>HTH,
>
>Marc


Marc,
Thanks for the reply,
My problem was infact not a problem.
Becausing going into modify the view using the desinger
would yeild a feature not supported message and I would
not see my entire sql statement, I beleived that it
was not becomming a part of the databse.
As you point out, it does. So, I have been racking my
brains out on a problem that was never a problem at all.


Thanks,

Chris