>>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?

Yes, that's what you get from running the GENDBC program. It will have a section with all the view DBSetProps after the SQL...