SELECT FieldPropertiesList FROM ('S'+sgcCurPre+'DD1') ORDER BY SortField INTO CURSOR SomeThing
SCAN
DO you stuff here
ENDSCAN
<\PRE>
hth,
Frank Camp
>Here is what I am doing:
>
>Using free tables.
>Looping through the field collection and getting the caption from the Promatrix data dictionary and setting the caption.
>
>I would like after setting all the captions to order the fields by caption name within table. Any ideas?
>
>JackFrank Camp