Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getwordnum working wrong
Message
From
08/02/2006 11:23:08
 
 
To
08/02/2006 10:00:09
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01094614
Message ID:
01094662
Views:
10
clear

lc_sele = "HP%DRUCKER AND (PRICE>100,00) AND (PRICE<200,00)"

* why this whole work is it a mystery ?

lcTest=Strtran(lc_sele,' AND ',chr(249)) && or some other CHR() value which is never used!
?GETWORDCOUNT(lcTest,chr(249))

* ALINES do all the work
FOR k=1 TO ALINES(andItems,lc_sele,' AND ')
	? k,CHR(9), andItems[k]
NEXT 
>Bingo!
>Thank you very much!
>
>
>>This is the CORRECT way to do it:
>>
>>lc_sele = "HP%DRUCKER AND (PRICE>100,00) AND (PRICE<200,00)"
>>lcTest=Strtran(lc_sele,' AND ',chr(249)) && or some other CHR() value which is never used!
>>?GETWORDCOUNT(lcTest,chr(249))
>>
>>>Hello,
>>>Here is little example
>>>
>>>lc_sele = "HP%DRUCKER AND (PRICE>100,00) AND (PRICE<200,00)"
>>>?GETWORDCOUNT(lc_sele," AND ")    && return 4
>>>?GETWORDNUM(lc_sele,1," AND ")     && return HP%
>>>?GETWORDNUM(lc_sele,2," AND ")     && return RUCKER
>>>?GETWORDNUM(lc_sele,3," AND ")     && return (PRICE>100,00)
>>>?GETWORDNUM(lc_sele,4," AND ")     && return (PRICE<200,00)
>>>
>>>
>>>Why? 1-2?
>>>
>>>Denis
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform