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?


Oscar

>Oscar,
>
>Try
>
>select field1, field2, ..., 000.00000000 as MyNumericField ...
>
>HTH
>>I need to prepare a cursor column as n (12, 8)
>>
>>I’m trying:
>>
>> select field1, field2, ..., val(“000.00000000”) as MyNumericField ...
>>
>>
>>but I’m getting a numeric with format n(15,2) for MyNumericField
>>
>>Could somebody give a hint in order to get the numeric field as n(12,8)?
>>
>>Thanks in advance and regards.
>>
>>
>>Oscar Corte