Page History

Div

style	display:none

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.

Div

id	description

HTML Table

id
class	servoy sSummary

Colgroup Tag

Col

width	80px

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

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.

HTML Table

id	constant
class	servoy sDetail

Colgroup Tag

Col

colspan	2
width	100%

Col

Table Head (thead)

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Constants Details

Table Body (tbody)

id	TYPE_BIG_DECIMAL

Table Row (tr)

id	name

Table Cell (td)
TYPE_BIG_DECIMAL

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_BIG_INTEGER

Table Row (tr)

id	name

Table Cell (td)
TYPE_BIG_INTEGER

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_BINARY

Table Row (tr)

id	name

Table Cell (td)
TYPE_BINARY

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_BLOB

Table Row (tr)

id	name

Table Cell (td)
TYPE_BLOB

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_BOOLEAN

Table Row (tr)

id	name

Table Cell (td)
TYPE_BOOLEAN

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_BYTE

Table Row (tr)

id	name

Table Cell (td)
TYPE_BYTE

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_CHARACTER

Table Row (tr)

id	name

Table Cell (td)
TYPE_CHARACTER

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_CLOB

Table Row (tr)

id	name

Table Cell (td)
TYPE_CLOB

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_DATE

Table Row (tr)

id	name

Table Cell (td)
TYPE_DATE

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_DOUBLE

Table Row (tr)

id	name

Table Cell (td)
TYPE_DOUBLE

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_FLOAT

Table Row (tr)

id	name

Table Cell (td)
TYPE_FLOAT

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_IMAGE

Table Row (tr)

id	name

Table Cell (td)
TYPE_IMAGE

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_INTEGER

Table Row (tr)

id	name

Table Cell (td)
TYPE_INTEGER

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_SHORT

Table Row (tr)

id	name

Table Cell (td)
TYPE_SHORT

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_STRING

Table Row (tr)

id	name

Table Cell (td)
TYPE_STRING

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_TEXT

Table Row (tr)

id	name

Table Cell (td)
TYPE_TEXT

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_TIME

Table Row (tr)

id	name

Table Cell (td)
TYPE_TIME

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_TIMESTAMP

Table Row (tr)

id	name

Table Cell (td)
TYPE_TIMESTAMP

Table Row (tr)

id	des

Table Cell (td)

Div

class	sIndent

Constant used for casting.

Table Row (tr)

id	ret

Table Cell (td)

Returns

Div

class	sIndent

String

Table Row (tr)

id	sam

Table Cell (td)

Sample

Div

class	sIndent

Code Block

language	javascript

/** @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())

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 12

New Version Current

Key

TYPE_BIG_DECIMAL

TYPE_BIG_INTEGER

TYPE_BINARY

TYPE_BLOB

TYPE_BOOLEAN

TYPE_BYTE

TYPE_CHARACTER

TYPE_CLOB

TYPE_DATE

TYPE_DOUBLE

TYPE_FLOAT

TYPE_IMAGE

TYPE_INTEGER

TYPE_SHORT

TYPE_STRING

TYPE_TEXT

TYPE_TIME

TYPE_TIMESTAMP