I had it backward maybe

calc today() as "newf"

the point was the "calc"  part determines field type

Bernie van't Hof <onrequest@somewhere> wrote:
>Older QBE (remember I never got past DOS) had it the other way round 
>(like sql):
>
>CALC "" AS newf
>CALC "" AS "newf"
>CALC 0 AS newf
>
>It also factored in the QBE source column type when determining the 
>resultant new column type.
>
>- Bernie
>
>On 30/5/20 3:54 am, Kevin Zawicki wrote:
>> In QBE you can calc add a column to the answer and somewhat control the
type.
>> I think Paradox types the result as needed.
>> 
>> calc "newf" as today()
>> calc "newf" as "AAAAAAAAAAA"
>> calc "newf" as "AAAAAAAAAAAAAAAAAAAAAAAA"
>> calc "newf" as 1
>> 
>> to get a set field type
>> The change the column values to blanks.
>> etc.
>> 
>> 
>> 
>> If you need exact control, you have to restructure or alter or use a dummy
>> table preset.
>> 
>> Kevin Baker <shcsbaker@gmail.com> wrote:
>>> Been playing around with this over the last few days. And getting
>>> stumped on how to convert a calc blank as MyField.  When I use the QBE,
>> 
>>> then use ShowSQL, it converts to NULL as MyField, but I don't think I
>>> have a say in what kind of field myField is (field type)
>> 
>