Page History

{div:style=}

Wiki Markup

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.

\\ \\ Enter additional information related to this

Enter additional information related to this 'class'

inside

the

\

{div}

macro

with

'id=description'

{div} {div:id=description}{div}\\ {table:id=|class=servoy sSummary}{colgroup}{column:width=80px|padding=0px}{column}{column}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=2}Constants Summary{th}{tr}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BIG_DECIMAL] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BIG_INTEGER] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BINARY] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BLOB] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BOOLEAN] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_BYTE] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_CHARACTER] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_CLOB] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_DATE] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_DOUBLE] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_FLOAT] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_IMAGE] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_INTEGER] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_SHORT] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_STRING] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_TEXT] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_TIME] Constant used for casting.{td}{tr}{tbody}{tbody}{tr}{td}[String]{td}{td}[#TYPE_TIMESTAMP] Constant used for casting.{td}{tr}{tbody}{table}\\ {table:id=constant|class=servoy sDetail}{colgroup}{column:width=100%|padding=0px}{column}{colgroup}{tr:style=height: 30px;}{th:colspan=1}Constants Details{th}{tr}{tbody:id=TYPE_BIG_DECIMAL}{tr:id=name}{td}h6.TYPE_BIG_DECIMAL{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

Div

id	description

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

Table Row (tr)

Table Cell (td)
String

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

Table Body (tbody)

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

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Table Body (tbody)

id	TYPE_BIG_INTEGER

}{

Table Row (tr)

:

id

=

	name

}{td}h6.

Table Cell (td)
TYPE_BIG_INTEGER

{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BINARY}{tr:id=name}{td}h6.TYPE_BINARY{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BLOB}{tr:id=name}{td}h6.TYPE_BLOB{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BOOLEAN}{tr:id=name}{td}h6.TYPE_BOOLEAN{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_BYTE}{tr:id=name}{td}h6.TYPE_BYTE{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_CHARACTER}{tr:id=name}{td}h6.TYPE_CHARACTER{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_CLOB}{tr:id=name}{td}h6.TYPE_CLOB{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_DATE}{tr:id=name}{td}h6.TYPE_DATE{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_DOUBLE}{tr:id=name}{td}h6.TYPE_DOUBLE{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_FLOAT}{tr:id=name}{td}h6.TYPE_FLOAT{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_IMAGE}{tr:id=name}{td}h6.TYPE_IMAGE{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_INTEGER}{tr:id=name}{td}h6.TYPE_INTEGER{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_SHORT}{tr:id=name}{td}h6.TYPE_SHORT{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_STRING}{tr:id=name}{td}h6.TYPE_STRING{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_TEXT}{tr:id=name}{td}h6.TYPE_TEXT{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_TIME}{tr:id=name}{td}h6.TYPE_TIME{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=TYPE_TIMESTAMP}{tr:id=name}{td}h6.TYPE_TIMESTAMP{td}{tr}{tr:id=des}{td}{div:class=sIndent}Constant used for casting.{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{div:class=sIndent}[String]{div}{td}{tr}{tr:id=sam}{td}*Sample*\\{div:class=sIndent}{code:language=javascript}

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())

{code}{div}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table}

Table Row (tr)

class	lastDetailRow

Table Cell (td)

Child pages

Versions Compared

Old Version 8

New Version 9

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