I would like to append all field names on load ... Is that possible??? I can do an alias or ,FIELD as FIELD1 but i would have to do it to all the fileds...
so is there an easy way to do this like ALIAS * as *1; or do i ahve to do all fieldnames individualy???
I believe you have to alias or rename fields individually. You can, however, rename using a loop. For instance, I can rename all fields in table Data like this:
FOR i=nooffields('Data') TO 1 STEP -1 LET vField=fieldname(i,'Data'); RENAME FIELD "$(vField)" TO "$(vField)1"; NEXT
