Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fields
Message
From
14/12/2006 03:43:24
 
 
To
14/12/2006 03:41:07
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Fields
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01177490
Message ID:
01177506
Views:
13
Check cpconvert() in help.

>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&&works
>>>	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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform