T_E4S_TRANS_APP

Overview

Package

Class

Tree

Deprecated

Index

Help

www.element4solution.com

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

e4s.db.systabledef
Class T_E4S_TRANS_APP_Sel

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterAnd
              e4s.db.E4DBSelect
                  e4s.db.systabledef.T_E4S_TRANS_APP_Sel

All Implemented Interfaces:: E4DBFilter_Intf, E4DBFilterAnd_Intf, E4DBSelect_Intf

public class T_E4S_TRANS_APP_Sel
extends E4DBSelect
implements E4DBSelect_Intf
extends E4DBSelect
implements E4DBSelect_Intf

SQL select for T_E4S_TRANS_APP: Application translations (this are all user interface text elements that are used within your application). The source language depends on a system property. created: 20050218 115525, modified: 20071103 125846. $LastChangedRevision: 5290 $ $LastChangedDate: 2009-12-09 18:45:55 +0100 (Mi, 09 Dez 2009) $

Column	Datatype		Remark
DATMOD	DATE		Date modified
DATNEW	DATE		Date created
DEST_LAN	Language	1	Destination language
DEST_TXT	STRING(255)		Translated text
SRC_LAN	Language	1	Source language
SRC_TXT	STRING(255)	12	Source text (to be translated)
UPD_COMPANY	`E4CompanyId` INTEGER		Update Company
UPD_MODE	STRING(4)		Update Mode
UPD_USER	`E4CompanyUserId` STRING(16)		Update User

Index 1: TRANS unique Index 2: IDX2

See Also:: T_E4S_TRANS_APP_Mod, T_E4S_TRANS_APP_Obj

Nested Class Summary
`static class`	`T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_And` Filter to be used as AND condition.
`static class`	`T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_Or` Filter to be used as OR condition.

Field Summary
`static E4DBColumnInfo`	`CI_DATMOD`
`static E4DBColumnInfo`	`CI_DATNEW`
`static E4DBColumnInfo`	`CI_DEST_LAN`
`static E4DBColumnInfo`	`CI_DEST_TXT`
`static E4DBColumnInfo`	`CI_SRC_LAN`
`static E4DBColumnInfo`	`CI_SRC_TXT`
`static E4DBColumnInfo`	`CI_UPD_COMPANY`
`static E4DBColumnInfo`	`CI_UPD_MODE`
`static E4DBColumnInfo`	`CI_UPD_USER`
`static E4DBColumnName`	`COL_DATMOD` DATE Date modified
`static E4DBColumnName`	`COL_DATNEW` DATE Date created
`static E4DBColumnName`	`COL_DEST_LAN` Language Destination language Member of index: TRANS.
`static E4DBColumnName`	`COL_DEST_TXT` STRING(255) Translated text
`static E4DBColumnName`	`COL_SRC_LAN` Language Source language Member of index: TRANS.
`static E4DBColumnName`	`COL_SRC_TXT` STRING(255) Source text (to be translated) Member of index: TRANS,#2.
`static E4DBColumnName`	`COL_UPD_COMPANY` E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company
`static E4DBColumnName`	`COL_UPD_MODE` STRING(4) Update Mode
`static E4DBColumnName`	`COL_UPD_USER` E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process.
`static E4DBColumnInfo[]`	`COLUMNS` Definition of database columns as array
`static E4DBIndexInfo`	`IDX_TRANS` Definition of index IDX_TRANS.
`static E4DBIndexInfo`	`IDX2` Definition of index IDX2.
`static E4DBIndexInfo[]`	`INDEXES` Definition of table indexes.
`static boolean`	`IS_CLIENT_DISTINCTIVE` This table does not enables client distinction.
`static boolean`	`IS_FREEDEF_POSSIBLE` This table does not enable freedefined database fields.
`static int`	`SVN_REVISION` SVN Revision Code.
`static E4DBTableName`	`TABLENAME` Name of the database table.

Fields inherited from class e4s.db.E4DBSelect
`COLUMN_NAME_COUNT, COLUMN_NAME_SUM, DB_DATEFORMAT, DB_DATEPICTURE, ms_isunicode, NULL`

Fields inherited from class e4s.db.E4DBFilter
`COMP_EMPTY, COMP_EQUALS, COMP_GREATER, COMP_GREATER_EQUAL, COMP_IN, COMP_IS_NOT_NULL, COMP_IS_NULL, COMP_LESS, COMP_LESS_EQUAL, COMP_LIKE, COMP_NOT_EMPTY, COMP_NOT_EQUALS, COMP_NOT_IN, COMP_NOT_LIKE`

Fields inherited from class e4s.util.E4Object
`CRLF, E4S_CORE_SYSTEM_LANGUAGE, NBSP, NULLSTR, URL_ENCODING_CHARSET`

Constructor Summary
`T_E4S_TRANS_APP_Sel()` Construct an object for selecting data from T_E4S_TRANS_APP using the default database connection.
`T_E4S_TRANS_APP_Sel(E4DBConnection_Intf dbcon)` Construct an object for selecting data from T_E4S_TRANS_APP using a database connection.
`T_E4S_TRANS_APP_Sel(T_E4S_TRANS_APP_Sel dbtable, boolean copy_where)` Construct an object for selecting data from T_E4S_TRANS_APP using an existing T_E4S_TRANS_APP_Sel instance.

Method Summary
`static java.lang.String`	`_getSVNVersionString()` Return the version info patched by CVS.
`boolean`	`canHaveFreeDefinedFields()` Check, if this table might have freedefined fields.
`static void`	`checkConsistency()` Check table consistency (structure only) against database.
`static void`	`checkConsistency(boolean check_structure, boolean check_index)` Check table consistency against database.
`static E4Fieldset`	`createFIELDSET()`
`static E4Fieldset`	`createFIELDSET(E4ApplObj_Intf applobj)`
`E4Fieldset`	`createFIELDSET(FORM form)`
`E4ID`	`E4ID()`
`static T_E4S_TRANS_APP_Obj`	`find_TRANS(E4DBConnection_Intf con, Language qDEST_LAN, Language qSRC_LAN, java.lang.String qSRC_TXT)` Find a record associates with index 1 (TRANS).
`static T_E4S_TRANS_APP_Obj`	`find_TRANS(Language qDEST_LAN, Language qSRC_LAN, java.lang.String qSRC_TXT)` Find a record associates with unique index 1 (TRANS).
`java.util.Date`	`get_DATMOD()` Get value for column DATMOD.
`java.util.Date`	`get_DATNEW()` Get value for column DATNEW.
`Language`	`get_DEST_LAN()` Get value for column DEST_LAN.
`java.lang.String`	`get_DEST_TXT()` Get value for column DEST_TXT.
`E4Fieldset`	`get_FIELDSET()`
`E4Fieldset`	`get_FIELDSET(FORM form)`
`Language`	`get_SRC_LAN()` Get value for column SRC_LAN.
`java.lang.String`	`get_SRC_TXT()` Get value for column SRC_TXT.
`E4CompanyId`	`get_UPD_COMPANY()` Get value for column UPD_COMPANY.
`java.lang.String`	`get_UPD_MODE()` Get value for column UPD_MODE.
`E4CompanyUserId`	`get_UPD_USER()` Get value for column UPD_USER.
`T_E4S_TRANS_APP_Obj`	`get()` Get the data object for T_E4S_TRANS_APP without reading freedefined values.
`void`	`get(E4Fieldset fieldset)`
`E4DBColumnInfo[]`	`getColInfo()` Get information about the columns defined for this database table.
`E4DBIndexInfo`	`getFirstPrimaryIndex()` Get the fields defined for the first unique index `IDX_TRANS`.
`E4DBIndexInfo[]`	`getIdxInfo()` Get information about the indexes defined for this database table.
`java.lang.Class`	`getModifyClass()` Get the defined and generated class for the modifications, this means INSERT, UPDATE and DELETE, related to this table T_E4S_TRANS_APP.
`java.lang.Class`	`getObjectClass()` Get the defined and generated class for the data-object related to this table.
`E4PersistantVector`	`getQuery()` `E4DBSelect.executeQuery()` and store elements of type T_E4S_TRANS_APP_Obj in a Vector.
`E4DBReference[]`	`getReferenceDelete(E4DBColumnName cName)` Return null.
`E4DBReference[]`	`getReferenceLookup(E4DBColumnName cName)` Return null.
`E4DBTypeUsage[]`	`getUsage(E4DBColumnName colname)` For the case, that the specified column is a e4s defined type (e.g.
`boolean`	`hasClientDistinctive()` Get the state if data of this table will be distincted by `E4Client`.
`static boolean`	`isEmpty(E4DBConnection_Intf con)` Check, if this table contains any data.
`E4DBModify_Intf`	`makeInstance_Modify(boolean copy_where)` Make an instance of the associated class for modification of database table entries.
`E4DBSelect_Intf`	`makeInstance(boolean copy_where)` Create a new instance for T_E4S_TRANS_APP_Sel
`boolean`	`next()` Fetch next record.
`T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_Or`	`or()`
`void`	`sort_DATMOD_descending()` Sort descending by column DATMOD.
`void`	`sort_DATMOD()` Sort ascending by column DATMOD.
`void`	`sort_DATNEW_descending()` Sort descending by column DATNEW.
`void`	`sort_DATNEW()` Sort ascending by column DATNEW.
`void`	`sort_DEST_LAN_descending()` Sort descending by column DEST_LAN.
`void`	`sort_DEST_LAN()` Sort ascending by column DEST_LAN.
`void`	`sort_DEST_TXT_descending()` Sort descending by column DEST_TXT.
`void`	`sort_DEST_TXT()` Sort ascending by column DEST_TXT.
`void`	`sort_SRC_LAN_descending()` Sort descending by column SRC_LAN.
`void`	`sort_SRC_LAN()` Sort ascending by column SRC_LAN.
`void`	`sort_SRC_TXT_descending()` Sort descending by column SRC_TXT.
`void`	`sort_SRC_TXT()` Sort ascending by column SRC_TXT.
`void`	`sort_UPD_COMPANY_descending()` Sort descending by column UPD_COMPANY.
`void`	`sort_UPD_COMPANY()` Sort ascending by column UPD_COMPANY.
`void`	`sort_UPD_MODE_descending()` Sort descending by column UPD_MODE.
`void`	`sort_UPD_MODE()` Sort ascending by column UPD_MODE.
`void`	`sort_UPD_USER_descending()` Sort descending by column UPD_USER.
`void`	`sort_UPD_USER()` Sort ascending by column UPD_USER.
`int`	`toCsv(E4PrintStream out)` Export data from database table to CSV file (MS-Excel compatible input format).
`static int`	`toCsv(java.lang.String path)` Export data from database table to CSV file (MS-Excel input format).
`int`	`toSql(E4PrintStream out)` Export data from database table to SQL file.
`int`	`toSql(E4PrintStream out, int include_freefields)` Export data from database table to SQL script file.
`static void`	`toSql(java.lang.String path)` Export data from database table to SQL script file.
`static int`	`toSql(java.lang.String path, int include_freefields)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out, E4StatusInformation_Intf status)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out, int include_freefields)` Export data from database table to XML file.
`int`	`toXml(E4PrintStream out, int include_freefields, E4StatusInformation_Intf status)` Export data from database table to XML file.
`static void`	`toXml(java.lang.String path)` Export data from database table to XML file.
`static void`	`toXml(java.lang.String path, E4StatusInformation_Intf status)`
`static int`	`toXml(java.lang.String path, int include_freefields)` Export data from database table to XML file.
`static int`	`toXml(java.lang.String path, int include_freefields, E4DBColumnName distinctCol)` Export data from database table to XML file.
`static int`	`toXml(java.lang.String path, int include_freefields, E4StatusInformation_Intf status)` Export data from database table to XML file.
`static int`	`toXml(java.lang.String path, int include_freefields, E4StatusInformation_Intf status, E4DBColumnName distinctCol)` Export data from database table to XML file.
`void`	`where_DATMOD_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATMOD_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
`void`	`where_DATMOD_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
`void`	`where_DATMOD_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DATMOD.
`void`	`where_DATMOD_isNull()` Define a is-null filter (AND-ed WHERE) for column DATMOD.
`void`	`where_DATMOD_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATMOD(java.util.Date filter)` Define a filter (AND-ed WHERE) for column DATMOD.
`void`	`where_DATMOD(int operator, java.util.Date filter)` Define a filter (AND-ed WHERE with operator) for column DATMOD.
`void`	`where_DATNEW_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATNEW_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
`void`	`where_DATNEW_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
`void`	`where_DATNEW_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DATNEW.
`void`	`where_DATNEW_isNull()` Define a is-null filter (AND-ed WHERE) for column DATNEW.
`void`	`where_DATNEW_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DATNEW(java.util.Date filter)` Define a filter (AND-ed WHERE) for column DATNEW.
`void`	`where_DATNEW(int operator, java.util.Date filter)` Define a filter (AND-ed WHERE with operator) for column DATNEW.
`void`	`where_DEST_LAN_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DEST_LAN_in(Language[] filter)` Define a IN-filter (AND-ed WHERE) for column DEST_LAN.
`void`	`where_DEST_LAN_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_LAN.
`void`	`where_DEST_LAN_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_LAN.
`void`	`where_DEST_LAN_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DEST_LAN.
`void`	`where_DEST_LAN_isNull()` Define a is-null filter (AND-ed WHERE) for column DEST_LAN.
`void`	`where_DEST_LAN_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DEST_LAN.
`void`	`where_DEST_LAN_not_in(Language[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column DEST_LAN.
`void`	`where_DEST_LAN_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DEST_LAN(int operator, Language filter)` Define a filter (AND-ed WHERE with operator) for column DEST_LAN.
`void`	`where_DEST_LAN(Language filter)` Define a filter (AND-ed WHERE) for column DEST_LAN.
`void`	`where_DEST_TXT_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DEST_TXT_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column DEST_TXT.
`void`	`where_DEST_TXT_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_TXT.
`void`	`where_DEST_TXT_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_TXT.
`void`	`where_DEST_TXT_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DEST_TXT.
`void`	`where_DEST_TXT_isNull()` Define a is-null filter (AND-ed WHERE) for column DEST_TXT.
`void`	`where_DEST_TXT_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column DEST_TXT.
`void`	`where_DEST_TXT_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DEST_TXT(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column DEST_TXT.
`void`	`where_DEST_TXT(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DEST_TXT.
`void`	`where_SRC_LAN_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SRC_LAN_in(Language[] filter)` Define a IN-filter (AND-ed WHERE) for column SRC_LAN.
`void`	`where_SRC_LAN_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_LAN.
`void`	`where_SRC_LAN_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_LAN.
`void`	`where_SRC_LAN_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column SRC_LAN.
`void`	`where_SRC_LAN_isNull()` Define a is-null filter (AND-ed WHERE) for column SRC_LAN.
`void`	`where_SRC_LAN_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column SRC_LAN.
`void`	`where_SRC_LAN_not_in(Language[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column SRC_LAN.
`void`	`where_SRC_LAN_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SRC_LAN(int operator, Language filter)` Define a filter (AND-ed WHERE with operator) for column SRC_LAN.
`void`	`where_SRC_LAN(Language filter)` Define a filter (AND-ed WHERE) for column SRC_LAN.
`void`	`where_SRC_TXT_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SRC_TXT_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column SRC_TXT.
`void`	`where_SRC_TXT_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_TXT.
`void`	`where_SRC_TXT_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_TXT.
`void`	`where_SRC_TXT_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column SRC_TXT.
`void`	`where_SRC_TXT_isNull()` Define a is-null filter (AND-ed WHERE) for column SRC_TXT.
`void`	`where_SRC_TXT_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column SRC_TXT.
`void`	`where_SRC_TXT_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_SRC_TXT(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column SRC_TXT.
`void`	`where_SRC_TXT(java.lang.String filter)` Define a filter (AND-ed WHERE) for column SRC_TXT.
`void`	`where_UPD_COMPANY_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_UPD_COMPANY_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_UPD_COMPANY(E4CompanyId filter)` Define a filter (AND-ed WHERE) for column UPD_COMPANY.
`void`	`where_UPD_COMPANY(int operator, E4CompanyId filter)` Define a filter (AND-ed WHERE with operator) for column UPD_COMPANY.
`void`	`where_UPD_MODE_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_UPD_MODE_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column UPD_MODE.
`void`	`where_UPD_MODE_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_MODE.
`void`	`where_UPD_MODE_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_MODE.
`void`	`where_UPD_MODE_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column UPD_MODE.
`void`	`where_UPD_MODE_isNull()` Define a is-null filter (AND-ed WHERE) for column UPD_MODE.
`void`	`where_UPD_MODE_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column UPD_MODE.
`void`	`where_UPD_MODE_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_UPD_MODE(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column UPD_MODE.
`void`	`where_UPD_MODE(java.lang.String filter)` Define a filter (AND-ed WHERE) for column UPD_MODE.
`void`	`where_UPD_USER_in(E4CompanyUserId[] filter)` Define a IN-filter (AND-ed WHERE) for column UPD_USER.
`void`	`where_UPD_USER_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_UPD_USER_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_USER.
`void`	`where_UPD_USER_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_USER.
`void`	`where_UPD_USER_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column UPD_USER.
`void`	`where_UPD_USER_isNull()` Define a is-null filter (AND-ed WHERE) for column UPD_USER.
`void`	`where_UPD_USER_like(java.lang.String filter)` Define a filter (AND-ed WHERE) for column UPD_USER.
`void`	`where_UPD_USER_not_in(E4CompanyUserId[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column UPD_USER.
`void`	`where_UPD_USER_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_UPD_USER(E4CompanyUserId filter)` Define a filter (AND-ed WHERE) for column UPD_USER.
`void`	`where_UPD_USER(int operator, E4CompanyUserId filter)` Define a filter (AND-ed WHERE with operator) for column UPD_USER.

Methods inherited from class e4s.db.E4DBSelect
checkConsistencyIndex, checkConsistencyIndex, checkConsistencyTable, checkConsistencyTable, checkConsistencyTable, close, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csvHeader, data2csvHeader, disableLogging, enableLogging, enableUnicode, executeCount, executeCountQuery, executeCountQuery, executeCountQuery, executeDistinctQuery, executeDistinctQuery, executeMax, executeMaxDate, executeMaxString, executeMin, executeMinDate, executeMinString, executeQuery, executeQuery, executeQuery, executeSQL, executeSQL, executeSQL, executeSumQuery, executeSumQuery, executeSumQuery, finalize, getBoolean, getConnection, getDate, getDistinctData, getDouble, getE4Long, getE4String, getFloat, getInt, getLong, getMetaData, getResultSet, getStatement, getString, getTableName, isLogging, isTable, isUnicodeEnabled, isView, removeOwnTableColumn, reset, resetOrderBy, setConnection, setFilterQuery, setFilterQuery, setOrderBy, setOrderBy, setOrderExtended, supportsSorting, toDate, toString, toString

Methods inherited from class e4s.db.E4DBSelect

checkConsistencyIndex, checkConsistencyIndex, checkConsistencyTable, checkConsistencyTable, checkConsistencyTable, close, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csv, data2csvHeader, data2csvHeader, disableLogging, enableLogging, enableUnicode, executeCount, executeCountQuery, executeCountQuery, executeCountQuery, executeDistinctQuery, executeDistinctQuery, executeMax, executeMaxDate, executeMaxString, executeMin, executeMinDate, executeMinString, executeQuery, executeQuery, executeQuery, executeSQL, executeSQL, executeSQL, executeSumQuery, executeSumQuery, executeSumQuery, finalize, getBoolean, getConnection, getDate, getDistinctData, getDouble, getE4Long, getE4String, getFloat, getInt, getLong, getMetaData, getResultSet, getStatement, getString, getTableName, isLogging, isTable, isUnicodeEnabled, isView, removeOwnTableColumn, reset, resetOrderBy, setConnection, setFilterQuery, setFilterQuery, setOrderBy, setOrderBy, setOrderExtended, supportsSorting, toDate, toString, toString

Methods inherited from class e4s.db.E4DBFilterAnd
`getWhere, isEmpty, isNotEmpty, isNotNull, isNull, OR, setFilter_NOT, setFilter_NOT, setFilter_NOT, setFilter_NOT, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter`

Methods inherited from class e4s.db.E4DBFilterAnd

getWhere, isEmpty, isNotEmpty, isNotNull, isNull, OR, setFilter_NOT, setFilter_NOT, setFilter_NOT, setFilter_NOT, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter

Methods inherited from class e4s.db.E4DBFilter
`Escape, Escape, getApplObj, getClient, getSession, getWhere, isWhereDefined, OP, resetWhere, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter, setFilter, setWhere, toString`

Methods inherited from class e4s.util.E4Object
Calendar, CName, CName, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelSys, E4LabelSys, e4sCopyright, e4sVersion, encode, encode, encode, encodeHtml, encodeHtml, encodeHtml, encodeURL, encodeURL, encodeURL, getLINE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTraceMemory, HtmlEncode, HtmlEncode, HtmlEncode, isdecimal, isdigit, isnotok, isnotok, isnumeric, isok, isok, isok, isok, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingStack, mkdirs, null2nbsp, null2nbsp, null2nbsp, ok, ok, ok, ok, outPrintln, setLogFile4Trace, setTraceMemory, STACKTRACE, toDebug, toDouble, toFloat, toFloat, TRACE_CALLS, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, wait

Methods inherited from class e4s.util.E4Object

Calendar, CName, CName, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelSys, E4LabelSys, e4sCopyright, e4sVersion, encode, encode, encode, encodeHtml, encodeHtml, encodeHtml, encodeURL, encodeURL, encodeURL, getLINE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTraceMemory, HtmlEncode, HtmlEncode, HtmlEncode, isdecimal, isdigit, isnotok, isnotok, isnumeric, isok, isok, isok, isok, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingStack, mkdirs, null2nbsp, null2nbsp, null2nbsp, ok, ok, ok, ok, outPrintln, setLogFile4Trace, setTraceMemory, STACKTRACE, toDebug, toDouble, toFloat, toFloat, TRACE_CALLS, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, wait

Methods inherited from class java.lang.Object
`clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

Methods inherited from interface e4s.db.E4DBSelect_Intf
`close, executeQuery, getApplObj, getBoolean, getConnection, getDate, getFloat, getLong, getMetaData, getString, getTableName, getWhere, isTable, isView, isWhereDefined, reset, resetOrderBy, resetWhere, setConnection, setFilter, setFilter, setFilter, setFilter, setFilter, setFilter, setOrderBy, setWhere, supportsSorting, toString`

Methods inherited from interface e4s.db.E4DBFilter_Intf
`isWhereDefined, resetWhere`

Field Detail

TABLENAME

public static final E4DBTableName TABLENAME

Name of the database table.

SVN_REVISION

public static final int SVN_REVISION

SVN Revision Code.

IS_CLIENT_DISTINCTIVE

public static final boolean IS_CLIENT_DISTINCTIVE

This table does not enables client distinction.

See Also:: E4Client, hasClientDistinctive(), Constant Field Values

IS_FREEDEF_POSSIBLE

public static final boolean IS_FREEDEF_POSSIBLE

This table does not enable freedefined database fields.

See Also:: E4DBFreeFieldName, canHaveFreeDefinedFields(), Constant Field Values

COL_DATMOD

public static final E4DBColumnName COL_DATMOD

DATE Date modified

CI_DATMOD

public static final E4DBColumnInfo CI_DATMOD

COL_DATNEW

public static final E4DBColumnName COL_DATNEW

DATE Date created

CI_DATNEW

public static final E4DBColumnInfo CI_DATNEW

COL_DEST_LAN

public static final E4DBColumnName COL_DEST_LAN

Language Destination language Member of index: TRANS.

See Also:: IDX_TRANS

CI_DEST_LAN

public static final E4DBColumnInfo CI_DEST_LAN

COL_DEST_TXT

public static final E4DBColumnName COL_DEST_TXT

STRING(255) Translated text

CI_DEST_TXT

public static final E4DBColumnInfo CI_DEST_TXT

COL_SRC_LAN

public static final E4DBColumnName COL_SRC_LAN

Language Source language Member of index: TRANS.

See Also:: IDX_TRANS

CI_SRC_LAN

public static final E4DBColumnInfo CI_SRC_LAN

COL_SRC_TXT

public static final E4DBColumnName COL_SRC_TXT

STRING(255) Source text (to be translated) Member of index: TRANS,#2.

See Also:: IDX_TRANS, IDX2

CI_SRC_TXT

public static final E4DBColumnInfo CI_SRC_TXT

COL_UPD_COMPANY

public static final E4DBColumnName COL_UPD_COMPANY

E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company

See Also:: E4CompanyId

CI_UPD_COMPANY

public static final E4DBColumnInfo CI_UPD_COMPANY

COL_UPD_MODE

public static final E4DBColumnName COL_UPD_MODE

STRING(4) Update Mode

CI_UPD_MODE

public static final E4DBColumnInfo CI_UPD_MODE

COL_UPD_USER

public static final E4DBColumnName COL_UPD_USER

E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

See Also:: E4CompanyUserId

CI_UPD_USER

public static final E4DBColumnInfo CI_UPD_USER

COLUMNS

public static final E4DBColumnInfo[] COLUMNS

Definition of database columns as array

See Also:: INDEXES

IDX_TRANS

public static final E4DBIndexInfo IDX_TRANS

Definition of index IDX_TRANS.

See Also:: COL_SRC_TXT, COL_SRC_TXT, COL_SRC_LAN, COL_SRC_TXT, COL_SRC_TXT, COL_SRC_LAN, COL_DEST_LAN

IDX2

public static final E4DBIndexInfo IDX2

Definition of index IDX2.

See Also:: COL_SRC_TXT

INDEXES

public static final E4DBIndexInfo[] INDEXES

Definition of table indexes.

See Also:: COLUMNS

Constructor Detail

T_E4S_TRANS_APP_Sel

public T_E4S_TRANS_APP_Sel(E4DBConnection_Intf dbcon)

Construct an object for selecting data from T_E4S_TRANS_APP using a database connection.

Parameters:: dbcon - a database connection

T_E4S_TRANS_APP_Sel

public T_E4S_TRANS_APP_Sel()
                    throws E4DBException

Construct an object for selecting data from T_E4S_TRANS_APP using the default database connection.

Throws:: E4DBException

T_E4S_TRANS_APP_Sel

public T_E4S_TRANS_APP_Sel(T_E4S_TRANS_APP_Sel dbtable,
                           boolean copy_where)
                    throws E4DBException

Construct an object for selecting data from T_E4S_TRANS_APP using an existing T_E4S_TRANS_APP_Sel instance.

Parameters:: dbtable - a previous created T_E4S_TRANS_APP_Sel; copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException

Method Detail

or

public T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_Or or()

makeInstance

public E4DBSelect_Intf makeInstance(boolean copy_where)
                             throws E4DBException

Create a new instance for T_E4S_TRANS_APP_Sel

Specified by:: makeInstance in interface E4DBSelect_Intf

Parameters:: copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException

E4ID

public E4ID E4ID()

hasClientDistinctive

public boolean hasClientDistinctive()

Get the state if data of this table will be distincted by E4Client. This is the case, if the E4ApplObj_Intf object was involved during construction of the object.

Specified by:: hasClientDistinctive in interface E4DBSelect_Intf

Returns:: false (no client distinction for this table)
See Also:: E4Client, IS_CLIENT_DISTINCTIVE

canHaveFreeDefinedFields

public boolean canHaveFreeDefinedFields()

Check, if this table might have freedefined fields.

Specified by:: canHaveFreeDefinedFields in interface E4DBSelect_Intf

Returns:: false (table does not enable freedefined database fields)
See Also:: IS_FREEDEF_POSSIBLE

getModifyClass

public java.lang.Class getModifyClass()

Get the defined and generated class for the modifications, this means INSERT, UPDATE and DELETE, related to this table T_E4S_TRANS_APP.

Specified by:: getModifyClass in interface E4DBSelect_Intf

Returns:: class for the modifications
See Also:: E4DBModify_Intf, E4DBModifyFreefields_Intf, T_E4S_TRANS_APP_Mod

makeInstance_Modify

public E4DBModify_Intf makeInstance_Modify(boolean copy_where)
                                    throws E4DBException

Make an instance of the associated class for modification of database table entries. If an application object is defined, it will also be handled to the new created instance, as well as the database connection.

Specified by:: makeInstance_Modify in interface E4DBSelect_Intf

Parameters:: copy_where - if true, the WHERE statement from the table is also copied to the new created table.
Throws:: E4DBException
See Also:: makeInstance(boolean)

getObjectClass

public java.lang.Class getObjectClass()

Get the defined and generated class for the data-object related to this table.

Specified by:: getObjectClass in interface E4DBSelect_Intf

Returns:: the data object class
See Also:: T_E4S_TRANS_APP_Obj

getColInfo

public E4DBColumnInfo[] getColInfo()

Get information about the columns defined for this database table.

Specified by:: getColInfo in interface E4DBSelect_Intf

Returns:: null if no columns are defined, an array of E4DBColumnType objects
See Also:: COLUMNS

getIdxInfo

public E4DBIndexInfo[] getIdxInfo()

Get information about the indexes defined for this database table.

Returns:: null if no index is defined, an array of E4DBIndexInfo objects
See Also:: INDEXES

getFirstPrimaryIndex

public E4DBIndexInfo getFirstPrimaryIndex()

Get the fields defined for the first unique index IDX_TRANS.

Specified by:: getFirstPrimaryIndex in interface E4DBSelect_Intf
Overrides:: getFirstPrimaryIndex in class E4DBSelect

Returns:: IDX_TRANS.

public boolean next()
             throws E4DBException

Fetch next record.

Specified by:: next in interface E4DBSelect_Intf
Overrides:: next in class E4DBSelect

Returns:: true, if a record is available
Throws:: E4DBException

get_DATMOD

public java.util.Date get_DATMOD()
                          throws E4DBException

Get value for column DATMOD. DATE Date modified

Returns:: the database column value retrieved for field DATMOD
Throws:: E4DBException

get_DATNEW

public java.util.Date get_DATNEW()
                          throws E4DBException

Get value for column DATNEW. DATE Date created

Returns:: the database column value retrieved for field DATNEW
Throws:: E4DBException

get_DEST_LAN

public Language get_DEST_LAN()
                      throws E4DBException

Get value for column DEST_LAN. Language Destination language

Returns:: the database column value retrieved for field DEST_LAN
Throws:: E4DBException

get_DEST_TXT

public java.lang.String get_DEST_TXT()
                              throws E4DBException

Get value for column DEST_TXT. STRING(255) Translated text

Returns:: the database column value retrieved for field DEST_TXT
Throws:: E4DBException

get_SRC_LAN

public Language get_SRC_LAN()
                     throws E4DBException

Get value for column SRC_LAN. Language Source language

Returns:: the database column value retrieved for field SRC_LAN
Throws:: E4DBException

get_SRC_TXT

public java.lang.String get_SRC_TXT()
                             throws E4DBException

Get value for column SRC_TXT. STRING(255) Source text (to be translated)

Returns:: the database column value retrieved for field SRC_TXT
Throws:: E4DBException

get_UPD_COMPANY

public E4CompanyId get_UPD_COMPANY()
                            throws E4DBException

Get value for column UPD_COMPANY. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company

Returns:: the database column value retrieved for field UPD_COMPANY
Throws:: E4DBException
See Also:: E4CompanyId

get_UPD_MODE

public java.lang.String get_UPD_MODE()
                              throws E4DBException

Get value for column UPD_MODE. STRING(4) Update Mode

Returns:: the database column value retrieved for field UPD_MODE
Throws:: E4DBException

get_UPD_USER

public E4CompanyUserId get_UPD_USER()
                             throws E4DBException

Get value for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Returns:: the database column value retrieved for field UPD_USER
Throws:: E4DBException
See Also:: E4CompanyUserId

get

public T_E4S_TRANS_APP_Obj get()
                        throws E4DBException

Get the data object for T_E4S_TRANS_APP without reading freedefined values.

Parameters:: readfreefields - also include the freefields.
Returns:: the data object.
Throws:: E4DBException

getQuery

public E4PersistantVector getQuery()
                            throws E4DBException

E4DBSelect.executeQuery() and store elements of type T_E4S_TRANS_APP_Obj in a Vector. Perform a E4DBSelect.close() afterwards.

Throws:: E4DBException

sort_DATMOD

public void sort_DATMOD()

Sort ascending by column DATMOD. DATE Date modified

sort_DATMOD_descending

public void sort_DATMOD_descending()

Sort descending by column DATMOD. DATE Date modified

sort_DATNEW

public void sort_DATNEW()

Sort ascending by column DATNEW. DATE Date created

sort_DATNEW_descending

public void sort_DATNEW_descending()

Sort descending by column DATNEW. DATE Date created

sort_DEST_LAN

public void sort_DEST_LAN()

Sort ascending by column DEST_LAN. Language Destination language

sort_DEST_LAN_descending

public void sort_DEST_LAN_descending()

Sort descending by column DEST_LAN. Language Destination language

sort_DEST_TXT

public void sort_DEST_TXT()

Sort ascending by column DEST_TXT. STRING(255) Translated text

sort_DEST_TXT_descending

public void sort_DEST_TXT_descending()

Sort descending by column DEST_TXT. STRING(255) Translated text

sort_SRC_LAN

public void sort_SRC_LAN()

Sort ascending by column SRC_LAN. Language Source language

sort_SRC_LAN_descending

public void sort_SRC_LAN_descending()

Sort descending by column SRC_LAN. Language Source language

sort_SRC_TXT

public void sort_SRC_TXT()

Sort ascending by column SRC_TXT. STRING(255) Source text (to be translated)

sort_SRC_TXT_descending

public void sort_SRC_TXT_descending()

Sort descending by column SRC_TXT. STRING(255) Source text (to be translated)

sort_UPD_COMPANY

public void sort_UPD_COMPANY()

Sort ascending by column UPD_COMPANY. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company

See Also:: E4CompanyId

sort_UPD_COMPANY_descending

public void sort_UPD_COMPANY_descending()

Sort descending by column UPD_COMPANY. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company

See Also:: E4CompanyId

sort_UPD_MODE

public void sort_UPD_MODE()

Sort ascending by column UPD_MODE. STRING(4) Update Mode

sort_UPD_MODE_descending

public void sort_UPD_MODE_descending()

Sort descending by column UPD_MODE. STRING(4) Update Mode

sort_UPD_USER

public void sort_UPD_USER()

Sort ascending by column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

See Also:: E4CompanyUserId

sort_UPD_USER_descending

public void sort_UPD_USER_descending()

Sort descending by column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

See Also:: E4CompanyUserId

where_DATMOD

public void where_DATMOD(java.util.Date filter)
                  throws E4DBException

Define a filter (AND-ed WHERE) for column DATMOD. DATE Date modified

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DATMOD

public void where_DATMOD(int operator,
                         java.util.Date filter)
                  throws E4DBException

Define a filter (AND-ed WHERE with operator) for column DATMOD. DATE Date modified

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_DATMOD_isNull

public void where_DATMOD_isNull()
                         throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:: E4DBException

where_DATMOD_isNotNull

public void where_DATMOD_isNotNull()
                            throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:: E4DBException

where_DATMOD_in

public void where_DATMOD_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD. DATE Date modified

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DATMOD_notin

public void where_DATMOD_notin(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATMOD. DATE Date modified

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DATMOD_isEmpty

public void where_DATMOD_isEmpty()
                          throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:: E4DBException

where_DATMOD_isNotEmpty

public void where_DATMOD_isNotEmpty()
                             throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD. DATE Date modified

Throws:: E4DBException

where_DATNEW

public void where_DATNEW(java.util.Date filter)
                  throws E4DBException

Define a filter (AND-ed WHERE) for column DATNEW. DATE Date created

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DATNEW

public void where_DATNEW(int operator,
                         java.util.Date filter)
                  throws E4DBException

Define a filter (AND-ed WHERE with operator) for column DATNEW. DATE Date created

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_DATNEW_isNull

public void where_DATNEW_isNull()
                         throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW_isNotNull

public void where_DATNEW_isNotNull()
                            throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW_in

public void where_DATNEW_in(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW. DATE Date created

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DATNEW_notin

public void where_DATNEW_notin(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DATNEW. DATE Date created

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DATNEW_isEmpty

public void where_DATNEW_isEmpty()
                          throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW. DATE Date created

Throws:: E4DBException

where_DATNEW_isNotEmpty

public void where_DATNEW_isNotEmpty()
                             throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW. DATE Date created

Throws:: E4DBException

where_DEST_LAN

public void where_DEST_LAN(Language filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column DEST_LAN. Language Destination language

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DEST_LAN

public void where_DEST_LAN(int operator,
                           Language filter)
                    throws E4DBException

Define a filter (AND-ed WHERE with operator) for column DEST_LAN. Language Destination language

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_DEST_LAN_like

public void where_DEST_LAN_like(java.lang.String filter)
                         throws E4DBException

Define a filter (AND-ed WHERE) for column DEST_LAN. Language Destination language

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DEST_LAN_in

public void where_DEST_LAN_in(Language[] filter)
                       throws E4DBException

Define a IN-filter (AND-ed WHERE) for column DEST_LAN. Language Destination language

Throws:: E4DBException

where_DEST_LAN_not_in

public void where_DEST_LAN_not_in(Language[] filter)
                           throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column DEST_LAN. Language Destination language

Throws:: E4DBException

where_DEST_LAN_isNull

public void where_DEST_LAN_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DEST_LAN. Language Destination language

Throws:: E4DBException

where_DEST_LAN_isNotNull

public void where_DEST_LAN_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DEST_LAN. Language Destination language

Throws:: E4DBException

where_DEST_LAN_in

public void where_DEST_LAN_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DEST_LAN. Language Destination language

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DEST_LAN_notin

public void where_DEST_LAN_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DEST_LAN. Language Destination language

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DEST_LAN_isEmpty

public void where_DEST_LAN_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_LAN. Language Destination language

Throws:: E4DBException

where_DEST_LAN_isNotEmpty

public void where_DEST_LAN_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_LAN. Language Destination language

Throws:: E4DBException

where_DEST_TXT

public void where_DEST_TXT(java.lang.String filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column DEST_TXT. STRING(255) Translated text

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DEST_TXT

public void where_DEST_TXT(int operator,
                           java.lang.String filter)
                    throws E4DBException

Define a filter (AND-ed WHERE with operator) for column DEST_TXT. STRING(255) Translated text

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_DEST_TXT_in

public void where_DEST_TXT_in(java.lang.String[] filter)
                       throws E4DBException

Define a IN-filter (AND-ed WHERE) for column DEST_TXT. STRING(255) Translated text

Throws:: E4DBException

where_DEST_TXT_not_in

public void where_DEST_TXT_not_in(java.lang.String[] filter)
                           throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column DEST_TXT. STRING(255) Translated text

Throws:: E4DBException

where_DEST_TXT_isNull

public void where_DEST_TXT_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DEST_TXT. STRING(255) Translated text

Throws:: E4DBException

where_DEST_TXT_isNotNull

public void where_DEST_TXT_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DEST_TXT. STRING(255) Translated text

Throws:: E4DBException

where_DEST_TXT_in

public void where_DEST_TXT_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DEST_TXT. STRING(255) Translated text

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DEST_TXT_notin

public void where_DEST_TXT_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DEST_TXT. STRING(255) Translated text

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_DEST_TXT_isEmpty

public void where_DEST_TXT_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_TXT. STRING(255) Translated text

Throws:: E4DBException

where_DEST_TXT_isNotEmpty

public void where_DEST_TXT_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_TXT. STRING(255) Translated text

Throws:: E4DBException

where_SRC_LAN

public void where_SRC_LAN(Language filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column SRC_LAN. Language Source language

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SRC_LAN

public void where_SRC_LAN(int operator,
                          Language filter)
                   throws E4DBException

Define a filter (AND-ed WHERE with operator) for column SRC_LAN. Language Source language

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_SRC_LAN_like

public void where_SRC_LAN_like(java.lang.String filter)
                        throws E4DBException

Define a filter (AND-ed WHERE) for column SRC_LAN. Language Source language

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SRC_LAN_in

public void where_SRC_LAN_in(Language[] filter)
                      throws E4DBException

Define a IN-filter (AND-ed WHERE) for column SRC_LAN. Language Source language

Throws:: E4DBException

where_SRC_LAN_not_in

public void where_SRC_LAN_not_in(Language[] filter)
                          throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column SRC_LAN. Language Source language

Throws:: E4DBException

where_SRC_LAN_isNull

public void where_SRC_LAN_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column SRC_LAN. Language Source language

Throws:: E4DBException

where_SRC_LAN_isNotNull

public void where_SRC_LAN_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column SRC_LAN. Language Source language

Throws:: E4DBException

where_SRC_LAN_in

public void where_SRC_LAN_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SRC_LAN. Language Source language

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SRC_LAN_notin

public void where_SRC_LAN_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SRC_LAN. Language Source language

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SRC_LAN_isEmpty

public void where_SRC_LAN_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_LAN. Language Source language

Throws:: E4DBException

where_SRC_LAN_isNotEmpty

public void where_SRC_LAN_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_LAN. Language Source language

Throws:: E4DBException

where_SRC_TXT

public void where_SRC_TXT(java.lang.String filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column SRC_TXT. STRING(255) Source text (to be translated)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SRC_TXT

public void where_SRC_TXT(int operator,
                          java.lang.String filter)
                   throws E4DBException

Define a filter (AND-ed WHERE with operator) for column SRC_TXT. STRING(255) Source text (to be translated)

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_SRC_TXT_in

public void where_SRC_TXT_in(java.lang.String[] filter)
                      throws E4DBException

Define a IN-filter (AND-ed WHERE) for column SRC_TXT. STRING(255) Source text (to be translated)

Throws:: E4DBException

where_SRC_TXT_not_in

public void where_SRC_TXT_not_in(java.lang.String[] filter)
                          throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column SRC_TXT. STRING(255) Source text (to be translated)

Throws:: E4DBException

where_SRC_TXT_isNull

public void where_SRC_TXT_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column SRC_TXT. STRING(255) Source text (to be translated)

Throws:: E4DBException

where_SRC_TXT_isNotNull

public void where_SRC_TXT_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column SRC_TXT. STRING(255) Source text (to be translated)

Throws:: E4DBException

where_SRC_TXT_in

public void where_SRC_TXT_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SRC_TXT. STRING(255) Source text (to be translated)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SRC_TXT_notin

public void where_SRC_TXT_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SRC_TXT. STRING(255) Source text (to be translated)

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_SRC_TXT_isEmpty

public void where_SRC_TXT_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_TXT. STRING(255) Source text (to be translated)

Throws:: E4DBException

where_SRC_TXT_isNotEmpty

public void where_SRC_TXT_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_TXT. STRING(255) Source text (to be translated)

Throws:: E4DBException

where_UPD_COMPANY

public void where_UPD_COMPANY(E4CompanyId filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column UPD_COMPANY. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException
See Also:: E4CompanyId

where_UPD_COMPANY

public void where_UPD_COMPANY(int operator,
                              E4CompanyId filter)
                       throws E4DBException

Define a filter (AND-ed WHERE with operator) for column UPD_COMPANY. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException
See Also:: E4CompanyId

where_UPD_COMPANY_in

public void where_UPD_COMPANY_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UPD_COMPANY. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException
See Also:: E4CompanyId

where_UPD_COMPANY_notin

public void where_UPD_COMPANY_notin(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UPD_COMPANY. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Update Company

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException
See Also:: E4CompanyId

where_UPD_MODE

public void where_UPD_MODE(java.lang.String filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column UPD_MODE. STRING(4) Update Mode

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_UPD_MODE

public void where_UPD_MODE(int operator,
                           java.lang.String filter)
                    throws E4DBException

Define a filter (AND-ed WHERE with operator) for column UPD_MODE. STRING(4) Update Mode

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException

where_UPD_MODE_in

public void where_UPD_MODE_in(java.lang.String[] filter)
                       throws E4DBException

Define a IN-filter (AND-ed WHERE) for column UPD_MODE. STRING(4) Update Mode

Throws:: E4DBException

where_UPD_MODE_not_in

public void where_UPD_MODE_not_in(java.lang.String[] filter)
                           throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column UPD_MODE. STRING(4) Update Mode

Throws:: E4DBException

where_UPD_MODE_isNull

public void where_UPD_MODE_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column UPD_MODE. STRING(4) Update Mode

Throws:: E4DBException

where_UPD_MODE_isNotNull

public void where_UPD_MODE_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column UPD_MODE. STRING(4) Update Mode

Throws:: E4DBException

where_UPD_MODE_in

public void where_UPD_MODE_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UPD_MODE. STRING(4) Update Mode

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_UPD_MODE_notin

public void where_UPD_MODE_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UPD_MODE. STRING(4) Update Mode

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException

where_UPD_MODE_isEmpty

public void where_UPD_MODE_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_MODE. STRING(4) Update Mode

Throws:: E4DBException

where_UPD_MODE_isNotEmpty

public void where_UPD_MODE_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_MODE. STRING(4) Update Mode

Throws:: E4DBException

where_UPD_USER

public void where_UPD_USER(E4CompanyUserId filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER

public void where_UPD_USER(int operator,
                           E4CompanyUserId filter)
                    throws E4DBException

Define a filter (AND-ed WHERE with operator) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Parameters:: filter - the value to be compared within the SQL statement; operator - the comparsion operator E4DBFilter
Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_like

public void where_UPD_USER_like(java.lang.String filter)
                         throws E4DBException

Define a filter (AND-ed WHERE) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_in

public void where_UPD_USER_in(E4CompanyUserId[] filter)
                       throws E4DBException

Define a IN-filter (AND-ed WHERE) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_not_in

public void where_UPD_USER_not_in(E4CompanyUserId[] filter)
                           throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_isNull

public void where_UPD_USER_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_isNotNull

public void where_UPD_USER_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_in

public void where_UPD_USER_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_notin

public void where_UPD_USER_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Parameters:: filter - the value to be compared within the SQL statement
Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_isEmpty

public void where_UPD_USER_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Throws:: E4DBException
See Also:: E4CompanyUserId

where_UPD_USER_isNotEmpty

public void where_UPD_USER_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_USER. E4CompanyUserId defined as e4s.util.E4String(16) User login name, unique identification for the user in the login process. Update User

Throws:: E4DBException
See Also:: E4CompanyUserId

getReferenceDelete

public E4DBReference[] getReferenceDelete(E4DBColumnName cName)

Description copied from class: E4DBSelect

Return null.

Specified by:: getReferenceDelete in interface E4DBSelect_Intf
Overrides:: getReferenceDelete in class E4DBSelect

Parameters:: cName - the column which references needs to be deleted (the "master")
Returns:: null, if no referential delete is defined for that column, or a list of references (the "detail")

getReferenceLookup

public E4DBReference[] getReferenceLookup(E4DBColumnName cName)

Description copied from class: E4DBSelect

Return null.

Specified by:: getReferenceLookup in interface E4DBSelect_Intf
Overrides:: getReferenceLookup in class E4DBSelect

Parameters:: cName - the column which references needs to be deleted (the "master")
Returns:: null, if no referential lookup is defined for that column, or a list of references (the "detail")

createFIELDSET

public E4Fieldset createFIELDSET(FORM form)

Specified by:: createFIELDSET in interface E4DBSelect_Intf

createFIELDSET

public static E4Fieldset createFIELDSET()

createFIELDSET

public static E4Fieldset createFIELDSET(E4ApplObj_Intf applobj)

get_FIELDSET

public E4Fieldset get_FIELDSET()
                        throws E4DBException

Throws:: E4DBException

get_FIELDSET

public E4Fieldset get_FIELDSET(FORM form)
                        throws E4DBException

Specified by:: get_FIELDSET in interface E4DBSelect_Intf

Throws:: E4DBException

get

public void get(E4Fieldset fieldset)
         throws E4DBException

Specified by:: get in interface E4DBSelect_Intf

Throws:: E4DBException

getUsage

public E4DBTypeUsage[] getUsage(E4DBColumnName colname)

For the case, that the specified column is a e4s defined type (e.g. E4Long, E4String) this function returns an array in which tables and columns this type is used, except the current table and the specified column.

Specified by:: getUsage in interface E4DBSelect_Intf

Parameters:: colname - the column to be checked
See Also:: E4DBIntegrity

isEmpty

public static boolean isEmpty(E4DBConnection_Intf con)
                       throws E4DBException

Check, if this table contains any data.

Parameters:: con - the connection
Throws:: E4DBException

find_TRANS

public static T_E4S_TRANS_APP_Obj find_TRANS(Language qDEST_LAN,
                                             Language qSRC_LAN,
                                             java.lang.String qSRC_TXT)
                                      throws E4DBException

Find a record associates with unique index 1 (TRANS).

Parameters:: qDEST_LAN - query Destination language; qSRC_LAN - query Source language; qSRC_TXT - query Source text (to be translated)
Throws:: E4DBException

find_TRANS

public static T_E4S_TRANS_APP_Obj find_TRANS(E4DBConnection_Intf con,
                                             Language qDEST_LAN,
                                             Language qSRC_LAN,
                                             java.lang.String qSRC_TXT)
                                      throws E4DBException

Find a record associates with index 1 (TRANS).

Parameters:: con - the database connection; qDEST_LAN - query Destination language; qSRC_LAN - query Source language; qSRC_TXT - query Source text (to be translated)
Throws:: E4DBException

toXml

public static void toXml(java.lang.String path)
                  throws E4DBException,
                         java.io.IOException

Export data from database table to XML file.

Parameters:: path - the output path.
Throws:: E4DBException; java.io.IOException

toXml

public int toXml(E4PrintStream out)
          throws E4DBException

Export data from database table to XML file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), toXml(String)

toXml

public static void toXml(java.lang.String path,
                         E4StatusInformation_Intf status)
                  throws E4DBException,
                         java.io.IOException

Throws:: E4DBException; java.io.IOException

toXml

public int toXml(E4PrintStream out,
                 E4StatusInformation_Intf status)
          throws E4DBException

Export data from database table to XML file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), toXml(String)

toXml

public int toXml(E4PrintStream out,
                 int include_freefields)
          throws E4DBException

Export data from database table to XML file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), toXml(String)

toXml

public int toXml(E4PrintStream out,
                 int include_freefields,
                 E4StatusInformation_Intf status)
          throws E4DBException

Export data from database table to XML file.

Parameters:: out - an opened output stream; include_freefields - mode, how freefields shall be included; status - an optional status tracker interface
Returns:: the number of records written
Throws:: E4DBException
See Also:: toCsv(e4s.util.E4PrintStream), toXml(String)

toXml

public static int toXml(java.lang.String path,
                        int include_freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(java.lang.String path,
                        int include_freefields,
                        E4DBColumnName distinctCol)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(java.lang.String path,
                        int include_freefields,
                        E4StatusInformation_Intf status)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(java.lang.String path,
                        int include_freefields,
                        E4StatusInformation_Intf status,
                        E4DBColumnName distinctCol)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toCsv

public int toCsv(E4PrintStream out)
          throws E4DBException

Export data from database table to CSV file (MS-Excel compatible input format).

Parameters:: out - an opened output stream; freefields - true include freefield values in export.
Returns:: the number of records written
Throws:: E4DBException

toCsv

public static int toCsv(java.lang.String path)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to CSV file (MS-Excel input format).

Parameters:: path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toSql

public static void toSql(java.lang.String path)
                  throws E4DBException,
                         java.io.IOException

Export data from database table to SQL script file.

Parameters:: path - the output path.
Throws:: E4DBException; java.io.IOException

toSql

public int toSql(E4PrintStream out)
          throws E4DBException

Export data from database table to SQL file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toXml(e4s.util.E4PrintStream), toCsv(e4s.util.E4PrintStream), toSql(String)

toSql

public int toSql(E4PrintStream out,
                 int include_freefields)
          throws E4DBException

Export data from database table to SQL script file.

Parameters:: out - an opened output stream
Returns:: the number of records written
Throws:: E4DBException
See Also:: toXml(e4s.util.E4PrintStream), toCsv(e4s.util.E4PrintStream), toSql(String)

toSql

public static int toSql(java.lang.String path,
                        int include_freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

checkConsistency

public static void checkConsistency()
                             throws E4DBException

Check table consistency (structure only) against database.

Throws:: E4DBException

checkConsistency

public static void checkConsistency(boolean check_structure,
                                    boolean check_index)
                             throws E4DBException

Check table consistency against database.

Parameters:: check_structure - check the table structure; check_index - check the index (can be time consuming on startup)
Throws:: E4DBException

_getSVNVersionString

public static java.lang.String _getSVNVersionString()

Return the version info patched by CVS.

Overview

Package

Class

Tree

Deprecated

Index

Help

www.element4solution.com

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

e4s.db.systabledef Class T_E4S_TRANS_APP_Sel

TABLENAME

SVN_REVISION

IS_CLIENT_DISTINCTIVE

IS_FREEDEF_POSSIBLE

COL_DATMOD

CI_DATMOD

COL_DATNEW

CI_DATNEW

COL_DEST_LAN

CI_DEST_LAN

COL_DEST_TXT

CI_DEST_TXT

COL_SRC_LAN

CI_SRC_LAN

COL_SRC_TXT

CI_SRC_TXT

COL_UPD_COMPANY

CI_UPD_COMPANY

COL_UPD_MODE

CI_UPD_MODE

COL_UPD_USER

CI_UPD_USER

COLUMNS

IDX_TRANS

IDX2

INDEXES

T_E4S_TRANS_APP_Sel

T_E4S_TRANS_APP_Sel

T_E4S_TRANS_APP_Sel

or

makeInstance

E4ID

hasClientDistinctive

canHaveFreeDefinedFields

getModifyClass

makeInstance_Modify

getObjectClass

getColInfo

getIdxInfo

getFirstPrimaryIndex

next

get_DATMOD

get_DATNEW

get_DEST_LAN

get_DEST_TXT

get_SRC_LAN

get_SRC_TXT

get_UPD_COMPANY

get_UPD_MODE

get_UPD_USER

get

getQuery

sort_DATMOD

sort_DATMOD_descending

sort_DATNEW

sort_DATNEW_descending

sort_DEST_LAN

sort_DEST_LAN_descending

sort_DEST_TXT

sort_DEST_TXT_descending

sort_SRC_LAN

sort_SRC_LAN_descending

sort_SRC_TXT

sort_SRC_TXT_descending

sort_UPD_COMPANY

sort_UPD_COMPANY_descending

sort_UPD_MODE

sort_UPD_MODE_descending

sort_UPD_USER

sort_UPD_USER_descending

where_DATMOD

where_DATMOD

where_DATMOD_isNull

where_DATMOD_isNotNull

where_DATMOD_in

where_DATMOD_notin

where_DATMOD_isEmpty

where_DATMOD_isNotEmpty

where_DATNEW

e4s.db.systabledef
Class T_E4S_TRANS_APP_Sel