Difference between revisions of "TYPE()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| + | =TYPE()= | ||
| + | |||
| + | |||
| + | ==Class== | ||
| + | Expressions and Type Conversion | ||
| + | |||
| + | |||
| + | ==Purpose== | ||
| + | Function to return a letter code that represents a data type | ||
| + | |||
| + | |||
| + | ==Syntax== | ||
TYPE(<expC>) | TYPE(<expC>) | ||
Revision as of 14:51, 20 March 2009
Contents
TYPE()
Class
Expressions and Type Conversion
Purpose
Function to return a letter code that represents a data type
Syntax
TYPE(<expC>)
See Also
ERROR(), ERRNO(), MESSAGE(), ON ERROR
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'. TYPE() will also return a 'U' for an undefined variable if SET CLIPPER is ON. TYPE() is primarily used to check for the existence of a variable, or the syntax of an expression.
Example
i = 10 ? type("i") N
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
