Robert,

The SQL page is not meant to be a two-way tool, you can not edit the view there, it is really only a display of what the designer has created.

If you need to create a view that is more complex than the view designer can handle you might want to get eview from the files section here. You can also just create them in code using the CREATE SQL VIEW command.

>Using VFP8 SP1, every time I make the simplest change in the View Designer SQL page and try to go back to the design screen, I get the error: "Command contains unrecognized phrase/keyword."
>
>I can create a remote view and everything works fine. I can save the view and reload the make changes and save again without any problems as long as the changes are made in the Designer. However, if I even add a single "spacebar" to the SQL page anywhere in the SQL statement, I get the above error when I try and exit back to the design mode and deleteing the space does not fix the problem.