Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Variable numeric or character
Message
From
10/01/2014 09:13:38
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01591614
Message ID:
01591625
Views:
45
>>>Does anyone know how I test if a variable is a number (value) or a character?
>>>
>>>thanks
>>>k
>>
>>Try this
>>
>>
>>
>>? Type_IsNumeric(m.myVar)
>>
>>? Type_IsChar(m.myVar)
>>
>>
>>#define T_NUMERIC_LIST	T_NUMERIC, T_DOUBLE, 'I', T_CURRENCY
>>*_______________________________________________________________________________
>>
>>function Type_IsNumeric(n)
>>	
>>	return 		inlist(vartype(m.n), T_NUMERIC_LIST)
>>
>>endfunc
>>*_______________________________________________________________________________
>>
>>function Type_IsChar(s)
>>
>>	return 	inlist(vartype(m.s), T_CHARACTER, T_MEMO, 'V', 'Q', 'W') 
>>
>>endfunc
>>*_______________________________________________________________________________
>>
>
>
>Beware, do not use TYPE(). It was added for speed but makes little difference and is known for returning the wrong result at times. I have seen this myself.


I know, it may return C or something else when the value is null

As in

x='qq'
x=null
?type('x') && C
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform