Constants Summary | |
---|---|
String | TYPE_BIG_DECIMAL Constant used for casting. |
String | TYPE_BIG_INTEGER Constant used for casting. |
String | TYPE_BINARY Constant used for casting. |
String | TYPE_BLOB Constant used for casting. |
String | TYPE_BOOLEAN Constant used for casting. |
String | TYPE_BYTE Constant used for casting. |
String | TYPE_CHARACTER Constant used for casting. |
String | TYPE_CLOB Constant used for casting. |
String | TYPE_DATE Constant used for casting. |
String | TYPE_DOUBLE Constant used for casting. |
String | TYPE_FLOAT Constant used for casting. |
String | TYPE_IMAGE Constant used for casting. |
String | TYPE_INTEGER Constant used for casting. |
String | TYPE_SHORT Constant used for casting. |
String | TYPE_STRING Constant used for casting. |
String | TYPE_TEXT Constant used for casting. |
String | TYPE_TIME Constant used for casting. |
String | TYPE_TIMESTAMP Constant used for casting. |
Constants Details | |
---|---|
TYPE_BIG_DECIMAL |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_BIG_INTEGER |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_BINARY |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_BLOB |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_BOOLEAN |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_BYTE |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_CHARACTER |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_CLOB |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_DATE |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_DOUBLE |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_FLOAT |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_IMAGE |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_INTEGER |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_SHORT |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_STRING |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_TEXT |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_TIME |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|
TYPE_TIMESTAMP |
|
Constant used for casting.
|
|
Returns |
|
Sample /** @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()) |
|