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

Sergey gave you the answer you wanted. However, I'd suggest that the best way to handle this situation would be to re-examine the design.