>>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.
>
>Michel,
>The view designer is *very* limited when it comes to joining more than just a few tables. So you'll be better to do everything in code.
>Personnaly I use xCase a lot, and its view designer has achieved till now all I wanted, with the notable exception that it can't build a view based on another view. But Elie Muyal, maker of xCase told this will be done in a future release.

In my case, I will only need to build one view so I can't afford to buy xCase just for it. My understand is that we can process that in only one line of code. Also, the View SQL of the view designer only show the SQL part. So, it seems to set up the updatable fields and other stuff we need to add additional lines of code to the SQL line. I'll take a look at some articles posted so far to start with.

Basically, what I need is to create the cursor, define a few field as updatable and save the changes.