David,

Thanks for the reply. However, I'm surpised at what you said that the View Designer is not meant to be a "two-way" tool. I heard (and read) may praised that Vfp8 finally made the SQL page "two-way." I know that there are limits to the complexity that the view designer can handle.

However, after a little more experimenting (see my other posts) I discovered that the problem was in my "editing" of the SQL page but, rather, the View Designer, could not even open the view that it had just saved. Althoug, the view can be called with the desired results, I can't open it with getting the error. I have discovered that I can delete the two braces {} and the 'oj' following the first brace and Vfp wil gladly reload the designer.

Thanks,
Robert