>>Brenda,
>>You can add it automatically if you select into a temp table and later erase it. >But it has the problem user also adds alias to new fields. Next time you would >need to process frx programmatically to remove aliases. Yet there is another >better way but fields show in memvar list (advantage you use unaliased >expressions) :
>
>>select * from ;
>> home()+"samples\data\customer" ;
>> where Contact = trim(thisform.text1.value) ;
>> nofilter ;
>> into cursor (lcCrs)
>>*create report myreport from alias() column
>>scatter memvar blank
>>modify report myreport
>>report form myreport preview
>
>
>What does the "scatter memvar blank" do? Also, my variable list has lots of other garbage in it. Is there any way to clean it up?
>
>Brenda
With "Scatter memvar blank" the fieldnames are placed in expression builder's memvar list. You can't touch system variables there (_*) but for others, if you don't need, you can release them.
Cetin