TYPE()

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