I will do it programmatically then,

I recently tried the new SQL- READWRITE clause and it is perfect forthis case


Regards


>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).