>Hi all
>
>Previously I used to use VFP6 and due to limitation of it I had to use View Editor by Steve Sawyer. Are the limitation removed and can the view designer in vfp9 suffice for all kinds of view SQLs?
>
>Please advise.

ViewEditor is still much better tool, than VFP9 native view editor. We're using it here, though I prefer to use CA as Borislav pointed out and I'm using Mark McCasland's builder for them.