TYPE()

From Recital Documentation Wiki
Revision as of 13:54, 9 June 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Class

Expressions and Type Conversion


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(), ON ERROR, 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'. 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