Chung,

I think you need the DBSETPROP command. You set the 'Field' properties and many other types of DB properties with that command. You define it outright N(14,4) right in code.

To learn how to use that code you download eView tool from the download section. eView is a great tool made by a guy who lives in Texas. With that tool you can generate code that creates and defines the view. Then you look at that code and learn to work with it.

Wally