>>It works. Would you provide exact code that's not working.
>
>
>nCnt = 1
>DIMENSION aMapFields(RECCOUNT('CM_fields_rrvw'),4)
>SELECT CM_fields_rrvw
>SCAN
> aMapFields(nCnt,1) = CM_fields_rrvw.field_name
> aMapFields(nCnt,2) = CM_fields_rrvw.field_type
> aMapFields(nCnt,3) = CM_fields_rrvw.field_width
> aMapFields(nCnt,4) = CM_fields_rrvw.field_decimal
> nCnt = nCnt + 1
>ENDSCAN
>
>...like I said works in 7 but not 8.
I think the problem is in field_name setting. In publicly distributed version if field_name had trailing spaces it'd not work. It's addressed and fixed AFAIK. For now you could do it like :
aMapFields(nCnt,1) = trim(CM_fields_rrvw.field_name)
PS: If CM_Fields_rrvw has the above structure you could directly create from it. "create myTable from CM_Fields_rrvw"
Cetin