>>>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.
>>
>Also, you can use the "Drew Speedie" method, where you begin with View Designer, add starting view to DBC. Then run GENDBC. Cut out the view code, paste it into a program, and edit it any way you see fit. Then run the PRG, adding your customized view any DBC you want. Save PRG to make future changes, and/or use to make other views...Works great.

Yes, but the code to set up the updatable fields it not part of the View Sql. Is there a way to obtain that?