Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to equal two Characters
Message
 
To
27/01/2010 16:30:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01446224
Message ID:
01446252
Views:
38
>so im doing this program where i make an id using the best command in VFP SUBSTR so its like if someone named Lisa Peters they get
>PETEL0001 but what if someone name Lorella Peters comes?it cant be the same so im trying to assign a Different number to Lorella using
>
>
>
	
>MESSAGEBOX(thisform.pageframe1.page5.txtgarnum2.Value )&&petel0001
>	MESSAGEBOX(cNextnum)&&petel0001
>
>IF ALLTRIM(cnextnum) =ALLTRIM(thisform.pageframe1.page5.txtgarnum2.Value) 
>	ape =(SUBSTR(cNextnum,8,2))
>	ape=ape+1
>	MESSAGEBOX(ape)
>	MESSAGEBOX('caught')
>	ELSE
>	MESSAGEBOX('not caught')
>	ENDIF 
>
>STR to int doesnt eexactly exist as far as i know
>for this to work...i would have to change Ape to an integer? and is this even the best way to go about doing what im trying to do?
ape =VAL((SUBSTR(cNextnum,8,2)))
_______________________________________________________________
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
Next
Reply
Map
View

Click here to load this message in the networking platform