servoy sReturnTypes 2 100% height: 30px; 2 Supported Clients sWordList SmartClient sWordList WebClient sWordList NGClient
servoy sSummary 12% 30% 58% height: 30px; 3 Constants Summary Constant used when setting or getting the sequence type of columns. Constant used when setting or getting the sequence type of columns. Constant used when setting or getting the type of columns. Constant used when setting or getting the flags of columns. Constant used when setting or getting the type of columns. Constant used when setting or getting the type of columns. Constant for column information indicating unset values. Constant used when setting or getting the type of columns. Constant used when setting or getting the row identifier type of columns. Constant used when setting or getting the row identifier type of columns. Constant used when setting or getting the sequence type of columns. Constant used when setting or getting the type of columns. Constant used when setting or getting the flags of columns. Constant used when setting or getting the sequence type of columns.
servoy sSummary 12% 30% 58% height: 30px; 3 Property Summary Get or set the allow-null flag of a new column. Get or set the row identifier type of the column. Get or set the sequence type of the column.
servoy sSummary 12% 30% 58% height: 30px; 3 Methods Summary Get the data provider id for this column (which is the same as name if not explicitly defined otherwise). Get the default format of the column. Get the description property of the column. Get the foreign type of the column. Get the length of the column as reported by the JDBC driver. Get the qualified name (including table name) of the column as known by the database. Returns a quoted version of the column name, if necessary, as defined by the actual database used. Get the name of the column as known by the database. Get the raw JDBC type of the column, which allows to check database specific types, like sting/byte column type variations. Get the scale of the column as reported by the JDBC driver. Get the title property of the column. Get the JDBC type of the column. Get the name JDBC type of the column. Check a flag of the column. void Set the database sequence name of the column, used for columns with sequence type JSColumn. void Set or clear a flag of a new column.
constant servoy sDetail 2 100% height:30px 2 Constants Details DATABASE_IDENTITY name DATABASE_IDENTITY des sIndent Constant used when setting or getting the sequence type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow DATABASE_SEQUENCE name DATABASE_SEQUENCE des sIndent Constant used when setting or getting the sequence type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow DATETIME name DATETIME des sIndent Constant used when setting or getting the type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow EXCLUDED_COLUMN name EXCLUDED_COLUMN des sIndent Constant used when setting or getting the flags of columns.
This flag identifies columns that are skipped in the sql. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow INTEGER name INTEGER des sIndent Constant used when setting or getting the type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow MEDIA name MEDIA des sIndent Constant used when setting or getting the type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow NONE name NONE des sIndent Constant for column information indicating unset values. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow NUMBER name NUMBER des sIndent Constant used when setting or getting the type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow PK_COLUMN name PK_COLUMN des sIndent Constant used when setting or getting the row identifier type of columns.
This value identifies columns that are defined as primary key in the database. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow ROWID_COLUMN name ROWID_COLUMN des sIndent Constant used when setting or getting the row identifier type of columns.
This value identifies columns that are defined as primary key by the developer (but not in the database). ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow SERVOY_SEQUENCE name SERVOY_SEQUENCE des sIndent Constant used when setting or getting the sequence type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow TEXT name TEXT des sIndent Constant used when setting or getting the type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow UUID_COLUMN name UUID_COLUMN des sIndent Constant used when setting or getting the flags of columns.
This flag identifies columns whose values are treated as UUID. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow UUID_GENERATOR name UUID_GENERATOR des sIndent Constant used when setting or getting the sequence type of columns. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow
property servoy sDetail 2 100% height:30px 2 Property Details allowNull name allowNull des sIndent Get or set the allow-null flag of a new column.
Note that when a column is added to an existing table, allowNull will always be set.
For a primary key column, the allowNull flag will be always off, for other columns the flag is set by default. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow rowIdentifierType name rowIdentifierType des sIndent Get or set the row identifier type of the column.
The sequence type is one of:
- JSColumn.PK_COLUMN
- JSColumn.ROWID_COLUMN
- JSColumn.NONE ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow sequenceType name sequenceType des sIndent Get or set the sequence type of the column.
The sequence type is one of:
- JSColumn.NONE
- JSColumn.SERVOY_SEQUENCE
- JSColumn.DATABASE_SEQUENCE
- JSColumn.DATABASE_IDENTITY
- JSColumn.UUID_GENERATOR; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow
function servoy sDetail 2 100% height:30px 2 Methods Details getDataProviderID name getDataProviderID() des sIndent Get the data provider id for this column (which is the same as name if not explicitly defined otherwise). ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getDefaultFormat name getDefaultFormat() des sIndent Get the default format of the column. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getDescription name getDescription() des sIndent Get the description property of the column. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getForeignType name getForeignType() des sIndent Get the foreign type of the column.
The foreign type can be defined design time as a foreign key reference to another table. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getLength name getLength() des sIndent Get the length of the column as reported by the JDBC driver. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getQualifiedName name getQualifiedName() des sIndent Get the qualified name (including table name) of the column as known by the database.
The name is quoted, if necessary, as defined by the actual database used. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getQuotedSQLName name getQuotedSQLName() des sIndent Returns a quoted version of the column name, if necessary, as defined by the actual database used. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getSQLName name getSQLName() des sIndent Get the name of the column as known by the database. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getSQLType name getSQLType() des sIndent Get the raw JDBC type of the column, which allows to check database specific types, like sting/byte column type variations. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getScale name getScale() des sIndent Get the scale of the column as reported by the JDBC driver. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getTitle name getTitle() des sIndent Get the title property of the column. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getType name getType() des sIndent Get the JDBC type of the column.
The type reported by the JDBC driver will be mapped to one of:
- JSColumn.DATETIME
- JSColumn.TEXT
- JSColumn.NUMBER
- JSColumn.INTEGER
- JSColumn.MEDIA ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow getTypeAsString name getTypeAsString() des sIndent Get the name JDBC type of the column.
The same mapping as defined in JSColumn.getType() is applied. ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow hasFlag name hasFlag(flag) des sIndent Check a flag of the column.
The flags are a bit pattern consisting of 1 or more of the following bits:
- JSColumn.UUID_COLUMN
- JSColumn.EXCLUDED_COLUMN prs Parameters
sIndent flag   ; ret Returns
sIndent clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow setDatabaseSequenceName name setDatabaseSequenceName(sequenceName) des sIndent Set the database sequence name of the column, used for columns with sequence type JSColumn.DATABASE_SEQUENCE. prs Parameters
sIndent sequenceName the sequence name clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow setFlag name setFlag(flag, set) des sIndent Set or clear a flag of a new column.
The flags are a bit pattern consisting of 1 or more of the following bits:
- JSColumn.UUID_COLUMN;
- JSColumn.EXCLUDED_COLUMN; prs Parameters
sIndent flag the flag to set set true for set flag, false for clear flag clients Supported Clients
sIndent SmartClient,WebClient,NGClient sam Sample
sIdent javascript lastDetailRow