Page History

...

HTML Table

id
class	servoy sSummary

Colgroup Tag

Column

padding	0px
width	80px

Column

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	2

Constants Summary

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_BIG_DECIMAL Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_BIG_INTEGER Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_BINARY Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_BLOB Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_BOOLEAN Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_BYTE Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_CHARACTER Constant used for casting.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_CLOB Constant used for casting.

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_DATE Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_DOUBLE Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_FLOAT Constant used for casting.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_IMAGE Constant used for casting.

tbody

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_INTEGER Constant used for casting.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_SHORT Constant used for casting.

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_STRING Constant used for casting.

Table Body (tbody)

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_TEXT Constant used for casting.

tbody

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_TIME Constant used for casting.

Table Row (tr)

Table Cell (td)
String

Table Cell (td)
#TYPETYPE_TIMESTAMP Constant used for casting.

HTML Table

id	constant
class	servoy sDetail

Colgroup Tag

Column

padding	0px
width	100%

Table Row (tr)

style	height: 30px;

Table Head (th)

colspan	1

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 9

New Version 10

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