Use zeros to tell VFP what sizes of the field you want or upgrade to VFP9 and use CAST() function
select Amount1, amount2, 000000.00 AS ResultComputation
What other field types are you interested in?
>I build a cursor. Within that cursor I want to add a field. The thing is that I will use that field to do computations.
>
>For example:
>
>select Amount1, amount2, ResultComputation
>
>Amount1 and Amount2 are fields in a table. I want to create ResultComputation
>
>How do I create a field without knowing the value it will hold?
>
>For example what if I want that field to hold N(8,2)?
>
>As long as we're at it how would I create other kinds of fields
>
>For example :
>
>I know that for a logical I can do this : Select .t. as LogicalField
>I know that for strings I can do this : select space( 20) as StringField
--sb--