>Chung
>
>You see the DBSETPROP command can be used to set a property just for that particular field. The width of the numeric field is being defined in a manner you don't want presumably when you run CREATE VIEW SQL command. After that command runs you use DBSETPROP('myView.myField','Field','DataType','N(5,2)'). So, you see it really is 1 line of code. I just rarely use the code, so I had to look it up.
>
>eView is a tool for you use, not to be distributed to your clients or users. It is merely a better visual tool than the standard VFP one to edit views. It also generates good code.
>
>Wally

eView is good indeed, at lease I can manipulate the SQL manually, thanks for that.