SBM ModScript Reference → Programming SBM ModScript → Constants → DBTypeConstants
Global const object for database types, used in SchemaColumn, SQLColumnDef, and SQL parameters.
SBM ModScript version: 11.3.
def getDBTypeNameText( type ) { switch( type ) { case(DBTypeConstants.BIGINT) { return "BigInteger"; } case(DBTypeConstants.INTEGER) { return "Integer"; } case(DBTypeConstants.SMALLINT) { return "SmallInteger"; } case(DBTypeConstants.TINYINT) { return "TinyInteger"; } case(DBTypeConstants.DOUBLE) { return "Double"; } case(DBTypeConstants.FLOAT) { return "Float"; } case(DBTypeConstants.DATETIME) { return "Datetime"; } case(DBTypeConstants.DECIMAL) { return "Decimal"; } case(DBTypeConstants.NUMERIC) { return "Numeric"; } case(DBTypeConstants.CHAR) { return "Char"; } case(DBTypeConstants.VARCHAR) { return "Varchar"; } case(DBTypeConstants.LONGVARCHAR) { return "LongVarchar"; } default { return "Unknown type: ${schema.type}"; } } } var record = Ext.CreateAppRecord( Ext.TableId( "TS_USERS" ) ); for( schema : record.GetSchemaColumns() ){ Ext.WriteStream( schema.name + " | " + getDBTypeNameText( schema.type ) + " | " + schema.length + "<br />"); }
Result:
TS_ID | Integer | 4 TS_LOGINID | Varchar | 64 TS_PASSWORD | Varchar | 258 TS_NAME | Varchar | 64 TS_TELEPHONE | Varchar | 64 TS_EMAIL | Varchar | 128 TS_STATUS | TinyInteger | 1 TS_FIELDSMASK | TinyInteger | 1 TS_NOTESMASK | TinyInteger | 1 TS_NUMNOTES | SmallInteger | 2 TS_CHGMASK | TinyInteger | 1 TS_NUMCHGS | SmallInteger | 2 TS_FILEMASK | Integer | 4 TS_NUMFILES | Integer | 4 TS_BROWSERMASK | Integer | 4 TS_ACCESSTYPE | TinyInteger | 1 TS_MAILCC | LongVarchar | 0 TS_HOMEPAGERPT | Integer | 4 TS_DATEPREFERENCE | TinyInteger | 1 TS_TIMEPREFERENCE | TinyInteger | 1 TS_OTHERUSER | Integer | 4 TS_FOLDERPROFILE | LongVarchar | 0 TS_STATECHANGEHISTORY | TinyInteger | 1 TS_MANAGEINCIDENTOPTIONS | TinyInteger | 1 TS_LICENSING | TinyInteger | 1 TS_PASSWORDPRIVILEGEOPTIONS | SmallInteger | 2 TS_PREFTABLEID | Integer | 4 TS_PASSWORDSETDATE | BigInteger | 8 TS_PASSWORDLENGTHOPTION | SmallInteger | 2 TS_GENERALMASK | TinyInteger | 1 TS_MEMO | LongVarchar | 0 TS_CONTACTID | Integer | 4 TS_CREATELOGINDATE | BigInteger | 8 TS_ALIASES | Varchar | 128 TS_TABORDER | LongVarchar | 0 TS_CHECKOLDPASSWORDS | SmallInteger | 2 TS_SPECIALCHAR | TinyInteger | 1 TS_LOCALE | Varchar | 32 TS_TIMEZONE | Varchar | 32 TS_CALENDARID | Integer | 4 TS_UUID | Varchar | 64 TS_NAMESPACEID | Integer | 4 TS_TERMSACCEPTED | BigInteger | 8 TS_AVATARRESOURCEID | Integer | 4 TS_TITLE | Varchar | 128 TS_MOBILEPHONE | Varchar | 64 TS_PREFERREDCONTACTMETHOD | TinyInteger | 1 TS_DATE_FORMAT | TinyInteger | 1 TS_TIMED | TinyInteger | 1 TS_LDAPSTATUS | TinyInteger | 1
Copyright © 2007–2019 Micro Focus or one of its affiliates. All rights reserved.