>I've been having troubles with the local view visual designer.
>
>I first created a view with several tables, I saved it and when I went back to it, I lost everything in it because I didn't select any field.
>
>Then, I create another view and included some fields. I saved it and when I went back to it, I lost all the relations.
>
>Then, I create another view and saved it. Now, everytime I try to click on it, it says Insufficient stack. I rebooted and the message is still there. So, I had to delete it.
>
>Now, would someone tell me if we should avoid the local view visual designer and do everything by hand?
>
>I need to create a view in order to be able to update the SQL after. I thought it would have been easier to make it visual. But, I guess I should be better in code.

I've created views both ways, with the designer and with the CREATE command in code somewhere. I use the CREATE command primarily because the view designer has limitations on the complexity of some queries. I have not lost a view definition in the manner in which you have though.

Steve