js editor
Web development
Returns the data type of an expression.
 Note: |
|---|
| VARTYPE(В ) is similar to the TYPE(В ) function, but VARTYPE(В ) is faster and does not require quotation marks ("") to enclose the specified expression. |
TYPE(cExpression [, 1]) |
Parameters
- cExpression
-
Specifies the expression, which can be a variable, array, field, memo field, or other expression, for which the data type is returned.
Note:
You must pass the expression as a character string by enclosing the expression with quotation marks (""). If you do not enclose the expression with quotation marks, TYPE(В ) evaluates the contents of the expression.
- 1
- Include the optional parameter 1 to determine if cExpression is an array or a Collection Class. COM objects are not supported with the 1 parameter.
Return Value
Character. TYPE( ) returns a character representing the data type of the specified expression.
The following table lists the character values that TYPE(В ) returns and their corresponding data types.
| Return value | Data type | ||
|---|---|---|---|
|
A |
Array (only returned when the optional 1 parameter is included) |
||
|
C |
Character, Varchar, Varchar (Binary) If the optional 1 parameter is included, a return value of C indicates that the data type is a collection. |
||
|
D |
Date |
||
|
G |
General |
||
|
L |
Logical |
||
|
M |
Memo |
||
|
N |
Numeric, Float, Double, or Integer |
||
|
O |
Object |
||
|
Q |
Blob, Varbinary |
||
|
S |
Screen
|
||
|
T |
DateTime |
||
|
U |
Undefined type of expression or cannot evaluate expression. If the optional 1 parameter is included, a return value of U indicates that the data type is not an array. |
||
|
Y |
Currency |
Remarks
If you pass an array as a parameter to TYPE(В ), the data type returned corresponds to the first element in the array. If you want to check the data type for a specific array element, you must specify that element in the parameter. For example:
| В |  Copy Code |
|---|---|
? TYPE("myarray[3]") | |
You can also use the TYPE(В ) function to check if a memory variable is an array. For example:
| В | Copy Code |
|---|---|
? TYPE("myarray[1]")#"U" | |
| Note: |
|---|
| TYPE(В ) cannot be used to evaluate UDFs (user-defined functions). |
Example
| В | Copy Code |
|---|---|
CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE customer && Opens Customer table
nTest = 1.01
cTest = "String"
CLEAR
? TYPE('customer.contact') && Displays C
? TYPE('(12 * 3) + 4') && Displays N
? TYPE('DATE( )') && Displays D
? TYPE('.F. OR .T.') && Displays L
? TYPE('ANSWER=42') && Displays U
? TYPE('$19.99') && Displays Y
? TYPE('nTest') && Displays N
? TYPE('cTest') && Displays C | |