>And here is another question
>
>Table1 has 10 numeric fields, Field names are different
>The code=1301002 is located in some fields.
>I want to replace it with 1501002,
>
>How to findout code=1301002 from whole table?
>Table1 has no index order set.
>
>I write following procedure but fifth line shows following error message
>"Operator/Operand type mismatch"
>(Please note all fields in table1 are numeric having numeric data)
>
>SELECT Table1
>lnTotalFields = AFIELDS(aryFields)
>FOR lnCounter = 1 TO lnTotalFields
> lcfieldname = aryFields(lnCounter,1)
> IF lcfieldname= 1301002
> REPLACE lcfieldname With 1501002
> ENDIF
>ENDFOR
>
>
>Please edit above code or suggest some others
Try the code I sent you!