i noticed in a FAQ a method to add additional properties to an object created with scatter NAME, ie scatter NAME Rates, would create an object with the properties of the current row from a table.

but what if you wish another property? the suggestion was to use the createobject and addproperty method of the session object.

[this may have been mentioned before]

a simpler, quick & dirty way is to use the select - sql and add any fieldname you want in addition to the existing ones. just do a select *,1 newproperty1, ' ', newproperty2,.t. newproperty3, etc. from table name into cursor whatever. then scatter than result to the NAME you wish.

you can even create a NAME with completely new properties if you dont state in the select to grab any of the existing fields. so

select ' ' newproperty1,.f. newproperty2 from sometablewhoknowswhich into cursor tempcur. then scatter that result and voila, NAME object with just the properties you want.

jim