hi,
sorry , field(WND_CHRS) have Arabic characters at another table
just i need any example or way to
replace (any fields is characters type) WITH NEWNAME&&&
thanks
>If I understand your question correctly, you can use transform() which will convert any value, both fields, variables and properties, into a character string.
>
>>hi all,
>>is there away to convert any fields at my table have characters type,
>>
>>without determine the fields that need to convert as.
>>
>>PUBLIC newname
>>
>>close database
>>USE CNV_WORD IN A ORDER 2
>>
>>USE code99 IN C
>>
>>SELECT C
>>NEW_WORK = SPACE(1)
>>IND_1 = 1
>>DO WHILE .NOT. EOF()
>>
>> OLD_NAME = cname
>> do cnv_work
>>* REPLACE cname WITH NEWNAME
>> replace (any fields is characters type) WITH NEWNAME
>> IF .NOT. EOF()
>> SKIP
>> ENDIF
>>ENDDO
>>brow
>>
>>procedure cnv_work
>> SELECT A
>> wrk_leng = len(alltrim(old_name))+1
>> DO WHILE IND_1 < wrk_leng
>> WRK_CHRS = SUBSTR(OLD_NAME,IND_1,1)
>> SEEK WRK_CHRS
>> IF FOUND()
>> NEW_WORK = NEW_WORK + WND_CHRS
>> ELSE
>> NEW_WORK = NEW_WORK + WRK_CHRS
>> ENDIF
>> IND_1 = IND_1 + 1
>> ENDDO
>> NEWNAME = NEW_WORK
>> NEW_WORK = SPACE(1)
>> IND_1 = 1
>> select c
>>return
>>
>>
>>thanks