I see. In this case you can create view programmaticaly.
>Hi Sergey
>
>
>You're right, the field keeps its structure but my problem is that if I create a view or store the sql statement. Next time I open it, it appears with one single cero on the integer side. Then truncating the integer part next time it is executed.
>
>Oscar
>
>>>Hi Daniel
>>>
>>>
>>>Somehow it is not working on the integer part of the number the field. It is getting truncated to a one single cero.
>>>
>>>Could it be a VFP SETing?
>>>
>>
>>It's not truncated. That's the way numberic fileds are displayed in VFP. Run LIST STRUCTURE to see that field created has format N(12,8).
--sb--