Child pages
  • QUERY_COLUMN_TYPES

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.
Enter additional information related to this 'class' inside the {div} macro with 'id=description'
Divcache
styleindexdisplay:none

...

iddescription

...

padding0px
width80px

...

Table Row (tr)
styleheight: 30px;
Table Head (th)
colspan2
Constants Summary
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_BIG_DECIMAL
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_BIG_INTEGER
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_BINARY
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_BLOB
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_BOOLEAN
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_BYTE
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_CHARACTER
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_CLOB
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_DATE
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_DOUBLE
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_FLOAT
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_IMAGE
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_INTEGER
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_SHORT
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_STRING
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_TEXT
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_TIME
Constant used for casting.
Table Row (tr)
Table Cell (td)
String
Table Cell (td)
TYPE_TIMESTAMP
Constant used for casting.

...

idconstant
classservoy sDetail

...

padding0px
width100%
Table Row (tr)
styleheight: 30px;
Table Head (th)
colspan1
Constants Details

...

idTYPE_BIG_DECIMAL
Table Row (tr)
idname
Table Cell (td)
TYPE_BIG_DECIMAL
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_BIG_INTEGER
Table Row (tr)
idname
Table Cell (td)
TYPE_BIG_INTEGER
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_BINARY
Table Row (tr)
idname
Table Cell (td)
TYPE_BINARY
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_BLOB
Table Row (tr)
idname
Table Cell (td)
TYPE_BLOB
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_BOOLEAN
Table Row (tr)
idname
Table Cell (td)
TYPE_BOOLEAN
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_BYTE
Table Row (tr)
idname
Table Cell (td)
TYPE_BYTE
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_CHARACTER
Table Row (tr)
idname
Table Cell (td)
TYPE_CHARACTER
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_CLOB
Table Row (tr)
idname
Table Cell (td)
TYPE_CLOB
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_DATE
Table Row (tr)
idname
Table Cell (td)
TYPE_DATE
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_DOUBLE
Table Row (tr)
idname
Table Cell (td)
TYPE_DOUBLE
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_FLOAT
Table Row (tr)
idname
Table Cell (td)
TYPE_FLOAT
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_IMAGE
Table Row (tr)
idname
Table Cell (td)
TYPE_IMAGE
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_INTEGER
Table Row (tr)
idname
Table Cell (td)
TYPE_INTEGER
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_SHORT
Table Row (tr)
idname
Table Cell (td)
TYPE_SHORT
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_STRING
Table Row (tr)
idname
Table Cell (td)
TYPE_STRING
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_TEXT
Table Row (tr)
idname
Table Cell (td)
TYPE_TEXT
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_TIME
Table Row (tr)
idname
Table Cell (td)
TYPE_TIME
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

idTYPE_TIMESTAMP
Table Row (tr)
idname
Table Cell (td)
TYPE_TIMESTAMP
Table Row (tr)
iddes
Table Cell (td)
Div
classsIndent
Constant used for casting.
Table Row (tr)
idret
Table Cell (td)
Returns
Div
classsIndent
String
Table Row (tr)
idsam
Table Cell (td)
Sample
Div
classsIndent
Code Block
languagejavascript
/** @type {QBSelect<db:/example_data/orders>} */
var query = databaseManager.createSelect('db:/example_data/orders') //$NON-NLS-1$
query.result.add(query.functions.cast("22",QUERY_COLUMN_TYPES.TYPE_INTEGER)).add(query.columns.amt_discount.cast(QUERY_COLUMN_TYPES.TYPE_STRING));
application.output(databaseManager.getDataSetByQuery(query,1).getAsHTML())

...

classlastDetailRow

...

true
refresh100d
showRefreshtrue
iddoc
titleRefresh page
showDatetrue
retryEnable

servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClient

servoy sSummary12%30%58%height: 30px;3Constants SummaryConstant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.Constant used for casting.

constantservoy sDetail2100%height:30px2Constants DetailsTYPE_BIG_DECIMALname

TYPE_BIG_DECIMAL

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRowTYPE_BIG_INTEGERname

TYPE_BIG_INTEGER

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_BINARYname

TYPE_BINARY

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_BLOBname

TYPE_BLOB

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_BOOLEANname

TYPE_BOOLEAN

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_BYTEname

TYPE_BYTE

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_CHARACTERname

TYPE_CHARACTER

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_CLOBname

TYPE_CLOB

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_DATEname

TYPE_DATE

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_DOUBLEname

TYPE_DOUBLE

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_FLOATname

TYPE_FLOAT

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_IMAGEname

TYPE_IMAGE

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_INTEGERname

TYPE_INTEGER

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_SHORTname

TYPE_SHORT

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_STRINGname

TYPE_STRING

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_TEXTname

TYPE_TEXT

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_TIMEname

TYPE_TIME

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow
TYPE_TIMESTAMPname

TYPE_TIMESTAMP

dessIndent
Constant used for casting.
ret

Returns

sIndent
clients

Supported Clients

sIndentSmartClient,WebClient,NGClient
sam

Sample

sIdentjavascript
lastDetailRow