Pre VFP9 solution would be:

create cursorTemplate (IDField I, MyMemo M, MyNULL c(10) NULL, etc.)
append blank
select * from cursorTemplate where 1=0 ;
union ;
select ... from real tables

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