I am still using VFP 6, unfortunately.
>Try
SELECT SomeField, CAST (MyFunc (OtherField) AS N (10, 2)) AS CalculatedValue;
> FROM MyTable;
> INTO CURSOR Temp
>
HTH
>
>>In a query similar to:
>>
>>
>>select SomeField, MyFunc(OtherField) as CalculatedValue;
>> from MyTable;
>> into cursor Temp
>>
>>
>>it may happen that MyFunc() returns .NULL. for some cases. If this happens, VFP informs me that the column doesn't accept NULL values.
>>
>>How do I make VFP allow null values? Of course, I could use NVL(...), but I do want NULL values in some cases, in order to know that there is some missing data.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)