> > 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