Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
String comparisons
Message
 
To
08/11/2006 13:54:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Miscellaneous
Thread ID:
01168143
Message ID:
01168197
Views:
9
>This works for me. Not sure if it will in VFP6 though:
>
>CREATE CURSOR myfile (cvalue C(20))
>FOR i = 1 TO 100
>   INSERT INTO myfile VALUES ('01-'+TRANSFORM(i))
>   IF i = 10
>      FOR i2 = 1 TO 10
>	 INSERT INTO myfile VALUES ('01-10'+ALLTRIM(STR(i2)))
>      ENDFOR
>   ENDIF			
>ENDFOR
>SELECT * FROM myfile WHERE ALLTRIM(cvalue) == "01-10" && pull only 01-10
>
Hi Tracy
This code works
SELECT * FROM myfile WHERE ALLTRIM(cvalue) == "01-10" && pull only 01-10
but with between function where to write "==" ;o)
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform