Skip to main content
Version: 2025.2

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