Difference between revisions of "TYPE()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return a letter code that represents a data type | Function to return a letter code that represents a data type | ||
| − | |||
==Syntax== | ==Syntax== | ||
TYPE(<expC>) | TYPE(<expC>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[ATOH()]], [[BIN2I()]], [[BIN2L()]], [[BIN2W()]], [[CAST()]], [[CTOD()]], [[CTOT()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ERROR()]], [[ERRNO()]], [[ETOS()]], [[HTOA()]], [[I2BIN()]], [[ISALPHA()]], [[ISDIGIT()]], [[L2BIN()]], [[MESSAGE()]], [[MTOS() | + | [[ATOH()]], [[BIN2I()]], [[BIN2L()]], [[BIN2W()]], [[CAST()]], [[CTOD()]], [[CTOT()]], [[DTOC()]], [[DTOM()]], [[DTOS()]], [[DTOV()]], [[ERROR()]], [[ERRNO()]], [[ETOS()]], [[HTOA()]], [[I2BIN()]], [[ISALPHA()]], [[ISDIGIT()]], [[L2BIN()]], [[MESSAGE()]], [[MTOS()]], [[STR()]], [[STRZERO()]], [[TTOC()]], [[TTOD()]], [[VAL()]], [[VARTYPE()]], [[VTOD()]] |
| − | + | ||
==Description== | ==Description== | ||
The TYPE() function returns a letter code which represents the data type of the expression in <expC>. The return value of the letter code is a character string from the table below. | The TYPE() function returns a letter code which represents the data type of the expression in <expC>. The return value of the letter code is a character string from the table below. | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 90: | Line 86: | ||
|} | |} | ||
| − | + | If <expC> contains a syntax error, or an undeclared variable, then TYPE() returns 'U'. | |
| − | If <expC> contains a syntax error, or an undeclared variable, then TYPE() returns 'U' | + | |
==Example== | ==Example== | ||
| Line 100: | Line 95: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Expressions and Type Conversion]] | [[Category:Expressions and Type Conversion]] | ||
[[Category:Expressions and Type Conversion Functions]] | [[Category:Expressions and Type Conversion Functions]] | ||
Revision as of 09:02, 10 February 2012
Contents
Purpose
Function to return a letter code that represents a data type
Syntax
TYPE(<expC>)
See Also
ATOH(), BIN2I(), BIN2L(), BIN2W(), CAST(), CTOD(), CTOT(), DTOC(), DTOM(), DTOS(), DTOV(), ERROR(), ERRNO(), ETOS(), HTOA(), I2BIN(), ISALPHA(), ISDIGIT(), L2BIN(), MESSAGE(), MTOS(), STR(), STRZERO(), TTOC(), TTOD(), VAL(), VARTYPE(), VTOD()
Description
The TYPE() function returns a letter code which represents the data type of the expression in <expC>. The return value of the letter code is a character string from the table below.
| Data type | Return Value |
|---|---|
| ARRAY (STATIC) | A |
| ARRAY (DYNAMIC) | O |
| BIGINT | N |
| BIT | L |
| BYTE | N |
| CHARACTER | C |
| CURRENCY | Y |
| DATE | D |
| DATETIME | T |
| DECIMAL | N |
| DOUBLE | N |
| FLOAT | N |
| GENERAL | G |
| INTEGER | N |
| LOGICAL | L |
| LONG VARCHAR | M |
| LONG VARBINARY | G |
| MEDIUMINT | N |
| MEMO | M |
| NUMERIC | N |
| OBJECT | O |
| PACKED | N |
| QUAD | N |
| REAL | N |
| SHORT | N |
| SMALLINT | N |
| Syntax error | U |
| TEXT | M |
| TIME | C |
| TIMESTAMP | T |
| TINYINT | N |
| Undefined | U |
| VAXDATE | C |
| VARCHAR | C |
| ZONED NUMERIC | C |
If <expC> contains a syntax error, or an undeclared variable, then TYPE() returns 'U'.
Example
i = 10 ? type("i") N
