>I create a view programatically, but all the fields are set as updatable. How can I define only one field as updatable.
>
>Thanks
>Carla

Carla, use gendbc to create a programmatic definition of the view, and look at the output. You will see the syntax you need to use to do this. You can also try my utility here available here in the files section called genview, it is much quicker and easier to use then gendbc, and creates only the output you need. The file is called gentable.zip.