Skip to main content
Version: 2026.1

SQLTYPES

Enthält die SqlTypen für das JDito

Methods​

isDateType​

isDateType(pType): boolean

Returns whether a database column is of the Date data type.

Parameters​

pType
number

The column type to be checked, e.g. returned from db.getColumnTypes().

Returns​

boolean

'true' or 'false', depending on whether it is the correct data type (timestamp) or not.

Example​

question.showMessage( SQLTYPES.isDateType( db.getColumnTypes("ORG", ["ORGNAME"])[0] ) );

isLOBType​

isLOBType(pType): boolean

Returns whether a database column is of the LOB (Large Object) data type or not.

Parameters​

pType
number

The column type to be checked, e.g. returned from db.getColumnTypes().

Returns​

boolean

'true' or 'false', depending on whether it is the correct data type (LOB) or not.

Example​

question.showMessage( SQLTYPES.isLOBType( db.getColumnTypes("ORG", ["ORGNAME"])[0] ) );

isNumberType​

isNumberType(pType): boolean

Returns whether a database column is of the Number data type or not.

Parameters​

pType
number

The column type to be checked, e.g. returned from db.getColumnTypes().

Returns​

boolean

'true' or 'false', depending on whether it is the correct data type (number) or not.

Example​

question.showMessage( SQLTYPES.isNumberType( db.getColumnTypes("ORG", ["ORGNAME"])[0] ) );

isTextType​

isTextType(pType): boolean

Returns whether a database column is of the Text data type or not.

Parameters​

pType
number

The column type to be checked, e.g. returned from db.getColumnTypes().

Returns​

boolean

'true' or 'false', depending on whether it is the correct data type (text) or not.

Example​

question.showMessage( SQLTYPES.isTextType( db.getColumnTypes("ORG", ["ORGNAME"])[0] ) );

Properties​

BIGINT​

number
​

BINARY​

number
​

BIT​

number
​

BLOB​

number
​

BOOLEAN​

number
​

CHAR​

number
​

CLOB​

number
​

number
​

DATE​

number
​

DECIMAL​

number
​

DOUBLE​

number
​

FLOAT​

number
​

INTEGER​

number
​

LONGNVARCHAR​

number
​

LONGVARBINARY​

number
​

LONGVARCHAR​

number
​

NCHAR​

number
​

NCLOB​

number
​

NULL​

number
​

NUMERIC​

number
​

NVARCHAR​

number
​

REAL​

number
​

REF​

number
​

ROWID​

number
​

SMALLINT​

number
​

SQLXML​

number
​

TIME​

number
​

TIME_WITH_TIMEZONE​

number
​

TIMESTAMP​

number
​

TIMESTAMP_WITH_TIMEZONE​

number
​

TINYINT​

number
​

VARBINARY​

number
​

VARCHAR​

number