Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to equal two Characters
Message
From
27/01/2010 16:47:21
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01446224
Message ID:
01446255
Views:
33
>>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)))
>
Thanks!! wow you>all ...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform