T_E4S_FREEFIELD_VAL

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_FREEFIELD_VAL_Sel

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

All Implemented Interfaces:: E4DBFilter_Intf, E4DBFilterAnd_Intf, E4DBSelect_Intf

public class T_E4S_FREEFIELD_VAL_Sel
extends E4DBSelect
implements E4DBSelect_Intf
extends E4DBSelect
implements E4DBSelect_Intf

SQL select for T_E4S_FREEFIELD_VAL: Values of free fields. created: 20050627 103740, modified: 20100318 114441. $LastChangedRevision: 5945 $ $LastChangedDate: 2010-03-23 17:15:03 +0100 (Di, 23 Mär 2010) $

Column	Datatype		Remark
DATMOD	DATE		Date modified
DATNEW	DATE		Date created
DB_TABLE	STRING(32)	1234	Associated table
FREEFIELD_NAME	STRING(32)	1234	Name of the free-field
IDX1	STRING(64)	134	Index #1
IDX2	STRING(64)	14	Index #2
IDX3	STRING(64)	1	Index #3
VAL	STRING(255)		Value

Index 1: MAIN3 Index 2: FIELD Index 3: MAIN1 Index 4: MAIN2

See Also:: T_E4S_FREEFIELD_VAL_Mod, T_E4S_FREEFIELD_VAL_Obj

Nested Class Summary
`static class`	`T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_And` Filter to be used as AND condition.
`static class`	`T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or` Filter to be used as OR condition.

Field Summary
`static E4DBColumnInfo`	`CI_DATMOD`
`static E4DBColumnInfo`	`CI_DATNEW`
`static E4DBColumnInfo`	`CI_DB_TABLE`
`static E4DBColumnInfo`	`CI_FREEFIELD_NAME`
`static E4DBColumnInfo`	`CI_IDX1`
`static E4DBColumnInfo`	`CI_IDX2`
`static E4DBColumnInfo`	`CI_IDX3`
`static E4DBColumnInfo`	`CI_VAL`
`static E4DBColumnName`	`COL_DATMOD` DATE Date modified
`static E4DBColumnName`	`COL_DATNEW` DATE Date created
`static E4DBColumnName`	`COL_DB_TABLE` STRING(32) Associated table Member of index: MAIN3,FIELD,MAIN1,MAIN2.
`static E4DBColumnName`	`COL_FREEFIELD_NAME` STRING(32) Name of the free-field Member of index: MAIN3,FIELD,MAIN1,MAIN2.
`static E4DBColumnName`	`COL_IDX1` STRING(64) Index #1 Member of index: MAIN3,MAIN1,MAIN2.
`static E4DBColumnName`	`COL_IDX2` STRING(64) Index #2 Member of index: MAIN3,MAIN2.
`static E4DBColumnName`	`COL_IDX3` STRING(64) Index #3 Member of index: MAIN3.
`static E4DBColumnName`	`COL_VAL` STRING(255) Value
`static E4DBColumnInfo[]`	`COLUMNS` Definition of database columns as array
`static E4DBIndexInfo`	`IDX_FIELD` Definition of index IDX_FIELD.
`static E4DBIndexInfo`	`IDX_MAIN1` Definition of index IDX_MAIN1.
`static E4DBIndexInfo`	`IDX_MAIN2` Definition of index IDX_MAIN2.
`static E4DBIndexInfo`	`IDX_MAIN3` Definition of index IDX_MAIN3.
`static E4DBIndexInfo[]`	`INDEXES` Definition of table indexes.
`static boolean`	`IS_CLIENT_DISTINCTIVE` This table 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_FREEFIELD_VAL_Sel(E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_FREEFIELD_VAL using the default database connection, the table uses client distinction.
`T_E4S_FREEFIELD_VAL_Sel(E4DBConnection_Intf dbcon, E4ApplObj_Intf applobj)` Construct an object for selecting data from T_E4S_FREEFIELD_VAL using a database connection, the table uses client distinction.
`T_E4S_FREEFIELD_VAL_Sel(T_E4S_FREEFIELD_VAL_Sel dbtable, boolean copy_where)` Construct an object for selecting data from T_E4S_FREEFIELD_VAL using an existing T_E4S_FREEFIELD_VAL_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 java.lang.String`	`findValue(E4DBTableName tablename, E4DBFreeFieldName fieldname, java.lang.String idx1, E4ApplObj_Intf applobj)`
`static java.lang.String`	`findValue(E4DBTableName tablename, E4DBFreeFieldName fieldname, java.lang.String idx1, java.lang.String idx2, E4ApplObj_Intf applobj)`
`static java.lang.String`	`findValue(E4DBTableName tablename, E4DBFreeFieldName fieldname, java.lang.String idx1, java.lang.String idx2, java.lang.String idx3, E4ApplObj_Intf applobj)`
`E4Client`	`get_CLIENT()` Get value for client.
`java.util.Date`	`get_DATMOD()` Get value for column DATMOD.
`java.util.Date`	`get_DATNEW()` Get value for column DATNEW.
`java.lang.String`	`get_DB_TABLE()` Get value for column DB_TABLE.
`E4Fieldset`	`get_FIELDSET()`
`E4Fieldset`	`get_FIELDSET(FORM form)`
`java.lang.String`	`get_FREEFIELD_NAME()` Get value for column FREEFIELD_NAME.
`java.lang.String`	`get_IDX1()` Get value for column IDX1.
`java.lang.String`	`get_IDX2()` Get value for column IDX2.
`java.lang.String`	`get_IDX3()` Get value for column IDX3.
`java.lang.String`	`get_VAL()` Get value for column VAL.
`T_E4S_FREEFIELD_VAL_Obj`	`get()` Get the data object for T_E4S_FREEFIELD_VAL without reading freedefined values.
`void`	`get(E4Fieldset fieldset)`
`E4DBColumnInfo[]`	`getColInfo()` Get information about the columns defined for this database table.
`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_FREEFIELD_VAL.
`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_FREEFIELD_VAL_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, E4ApplObj_Intf applobj)` 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_FREEFIELD_VAL_Sel
`boolean`	`next()` Fetch next record.
`T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_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_DB_TABLE_descending()` Sort descending by column DB_TABLE.
`void`	`sort_DB_TABLE()` Sort ascending by column DB_TABLE.
`void`	`sort_FREEFIELD_NAME_descending()` Sort descending by column FREEFIELD_NAME.
`void`	`sort_FREEFIELD_NAME()` Sort ascending by column FREEFIELD_NAME.
`void`	`sort_IDX1_descending()` Sort descending by column IDX1.
`void`	`sort_IDX1()` Sort ascending by column IDX1.
`void`	`sort_IDX2_descending()` Sort descending by column IDX2.
`void`	`sort_IDX2()` Sort ascending by column IDX2.
`void`	`sort_IDX3_descending()` Sort descending by column IDX3.
`void`	`sort_IDX3()` Sort ascending by column IDX3.
`void`	`sort_VAL_descending()` Sort descending by column VAL.
`void`	`sort_VAL()` Sort ascending by column VAL.
`static int`	`toCsv(E4ApplObj_Intf appobj, java.lang.String path)` Export data from database table to CSV file (MS-Excel input format).
`int`	`toCsv(E4PrintStream out)` Export data from database table to CSV file (MS-Excel compatible input format).
`static void`	`toSql(E4ApplObj_Intf applobj, java.lang.String path)` Export data from database table to SQL script file.
`static int`	`toSql(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields)` Export data from database table to XML file.
`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`	`toXml(E4ApplObj_Intf applobj, java.lang.String path)` Export data from database table to XML file.
`static void`	`toXml(E4ApplObj_Intf applobj, java.lang.String path, E4StatusInformation_Intf status)`
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4DBColumnName distinctCol)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4StatusInformation_Intf status)` Export data from database table to XML file.
`static int`	`toXml(E4ApplObj_Intf appobj, java.lang.String path, int include_freefields, E4StatusInformation_Intf status, E4DBColumnName distinctCol)` 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.
`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_DB_TABLE_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DB_TABLE_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column DB_TABLE.
`void`	`where_DB_TABLE_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DB_TABLE.
`void`	`where_DB_TABLE_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DB_TABLE.
`void`	`where_DB_TABLE_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column DB_TABLE.
`void`	`where_DB_TABLE_isNull()` Define a is-null filter (AND-ed WHERE) for column DB_TABLE.
`void`	`where_DB_TABLE_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column DB_TABLE.
`void`	`where_DB_TABLE_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_DB_TABLE(E4DBTableName tablename)`
`void`	`where_DB_TABLE(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column DB_TABLE.
`void`	`where_DB_TABLE(java.lang.String filter)` Define a filter (AND-ed WHERE) for column DB_TABLE.
`void`	`where_FREEFIELD_NAME_in(E4DBFreeFieldName[] freefields)`
`void`	`where_FREEFIELD_NAME_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_FREEFIELD_NAME_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column FREEFIELD_NAME.
`void`	`where_FREEFIELD_NAME_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FREEFIELD_NAME.
`void`	`where_FREEFIELD_NAME_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FREEFIELD_NAME.
`void`	`where_FREEFIELD_NAME_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column FREEFIELD_NAME.
`void`	`where_FREEFIELD_NAME_isNull()` Define a is-null filter (AND-ed WHERE) for column FREEFIELD_NAME.
`void`	`where_FREEFIELD_NAME_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column FREEFIELD_NAME.
`void`	`where_FREEFIELD_NAME_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_FREEFIELD_NAME(E4DBFreeFieldName fieldname)`
`void`	`where_FREEFIELD_NAME(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column FREEFIELD_NAME.
`void`	`where_FREEFIELD_NAME(java.lang.String filter)` Define a filter (AND-ed WHERE) for column FREEFIELD_NAME.
`void`	`where_IDX1_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_IDX1_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column IDX1.
`void`	`where_IDX1_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX1.
`void`	`where_IDX1_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX1.
`void`	`where_IDX1_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column IDX1.
`void`	`where_IDX1_isNull()` Define a is-null filter (AND-ed WHERE) for column IDX1.
`void`	`where_IDX1_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column IDX1.
`void`	`where_IDX1_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_IDX1(boolean val)`
`void`	`where_IDX1(java.util.Date val)`
`void`	`where_IDX1(double val)`
`void`	`where_IDX1(E4Long val)`
`void`	`where_IDX1(E4String val)`
`void`	`where_IDX1(int val)`
`void`	`where_IDX1(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column IDX1.
`void`	`where_IDX1(long val)`
`void`	`where_IDX1(java.lang.String filter)` Define a filter (AND-ed WHERE) for column IDX1.
`void`	`where_IDX2_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_IDX2_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column IDX2.
`void`	`where_IDX2_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX2.
`void`	`where_IDX2_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX2.
`void`	`where_IDX2_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column IDX2.
`void`	`where_IDX2_isNull()` Define a is-null filter (AND-ed WHERE) for column IDX2.
`void`	`where_IDX2_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column IDX2.
`void`	`where_IDX2_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_IDX2(boolean val)`
`void`	`where_IDX2(java.util.Date val)`
`void`	`where_IDX2(double val)`
`void`	`where_IDX2(E4Long val)`
`void`	`where_IDX2(E4String val)`
`void`	`where_IDX2(int val)`
`void`	`where_IDX2(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column IDX2.
`void`	`where_IDX2(long val)`
`void`	`where_IDX2(java.lang.String filter)` Define a filter (AND-ed WHERE) for column IDX2.
`void`	`where_IDX3_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_IDX3_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column IDX3.
`void`	`where_IDX3_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX3.
`void`	`where_IDX3_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX3.
`void`	`where_IDX3_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column IDX3.
`void`	`where_IDX3_isNull()` Define a is-null filter (AND-ed WHERE) for column IDX3.
`void`	`where_IDX3_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column IDX3.
`void`	`where_IDX3_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_IDX3(boolean val)`
`void`	`where_IDX3(java.util.Date val)`
`void`	`where_IDX3(double val)`
`void`	`where_IDX3(E4Long val)`
`void`	`where_IDX3(E4String val)`
`void`	`where_IDX3(int val)`
`void`	`where_IDX3(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column IDX3.
`void`	`where_IDX3(long val)`
`void`	`where_IDX3(java.lang.String filter)` Define a filter (AND-ed WHERE) for column IDX3.
`void`	`where_VAL_in(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_VAL_in(java.lang.String[] filter)` Define a IN-filter (AND-ed WHERE) for column VAL.
`void`	`where_VAL_isEmpty()` Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VAL.
`void`	`where_VAL_isNotEmpty()` Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VAL.
`void`	`where_VAL_isNotNull()` Define a is-NOT-null filter (AND-ed WHERE) for column VAL.
`void`	`where_VAL_isNull()` Define a is-null filter (AND-ed WHERE) for column VAL.
`void`	`where_VAL_not_in(java.lang.String[] filter)` Define a NOT-IN-filter (AND-ed WHERE) for column VAL.
`void`	`where_VAL_notin(E4DBSelectDistinct filter)` Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
`void`	`where_VAL(int operator, java.lang.String filter)` Define a filter (AND-ed WHERE with operator) for column VAL.
`void`	`where_VAL(java.lang.String filter)` Define a filter (AND-ed WHERE) for column VAL.

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, getFirstPrimaryIndex, 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, getFirstPrimaryIndex, 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, wait, wait, wait`

Methods inherited from interface e4s.db.E4DBSelect_Intf
`close, executeQuery, getApplObj, getBoolean, getConnection, getDate, getFirstPrimaryIndex, 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 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_DB_TABLE

public static final E4DBColumnName COL_DB_TABLE

STRING(32) Associated table Member of index: MAIN3,FIELD,MAIN1,MAIN2.

See Also:: IDX_MAIN3, IDX_FIELD, IDX_MAIN1, IDX_MAIN2

CI_DB_TABLE

public static final E4DBColumnInfo CI_DB_TABLE

COL_FREEFIELD_NAME

public static final E4DBColumnName COL_FREEFIELD_NAME

STRING(32) Name of the free-field Member of index: MAIN3,FIELD,MAIN1,MAIN2.

See Also:: IDX_MAIN3, IDX_FIELD, IDX_MAIN1, IDX_MAIN2

CI_FREEFIELD_NAME

public static final E4DBColumnInfo CI_FREEFIELD_NAME

COL_IDX1

public static final E4DBColumnName COL_IDX1

STRING(64) Index #1 Member of index: MAIN3,MAIN1,MAIN2.

See Also:: IDX_MAIN3, IDX_MAIN1, IDX_MAIN2

CI_IDX1

public static final E4DBColumnInfo CI_IDX1

COL_IDX2

public static final E4DBColumnName COL_IDX2

STRING(64) Index #2 Member of index: MAIN3,MAIN2.

See Also:: IDX_MAIN3, IDX_MAIN2

CI_IDX2

public static final E4DBColumnInfo CI_IDX2

COL_IDX3

public static final E4DBColumnName COL_IDX3

STRING(64) Index #3 Member of index: MAIN3.

See Also:: IDX_MAIN3

CI_IDX3

public static final E4DBColumnInfo CI_IDX3

COL_VAL

public static final E4DBColumnName COL_VAL

STRING(255) Value

CI_VAL

public static final E4DBColumnInfo CI_VAL

COLUMNS

public static final E4DBColumnInfo[] COLUMNS

Definition of database columns as array

See Also:: INDEXES

IDX_MAIN3

public static final E4DBIndexInfo IDX_MAIN3

Definition of index IDX_MAIN3.

See Also:: COL_IDX3, COL_IDX3, COL_IDX2, COL_IDX3, COL_IDX3, COL_IDX2, COL_IDX1, COL_IDX3, COL_IDX3, COL_IDX2, COL_IDX3, COL_IDX3, COL_IDX2, COL_IDX1, COL_FREEFIELD_NAME, COL_IDX3, COL_IDX3, COL_IDX2, COL_IDX3, COL_IDX3, COL_IDX2, COL_IDX1, COL_IDX3, COL_IDX3, COL_IDX2, COL_IDX3, COL_IDX3, COL_IDX2, COL_IDX1, COL_FREEFIELD_NAME, COL_DB_TABLE

IDX_FIELD

public static final E4DBIndexInfo IDX_FIELD

Definition of index IDX_FIELD.

See Also:: COL_FREEFIELD_NAME, COL_FREEFIELD_NAME, COL_DB_TABLE

IDX_MAIN1

public static final E4DBIndexInfo IDX_MAIN1

Definition of index IDX_MAIN1.

See Also:: COL_IDX1, COL_IDX1, COL_FREEFIELD_NAME, COL_IDX1, COL_IDX1, COL_FREEFIELD_NAME, COL_DB_TABLE

IDX_MAIN2

public static final E4DBIndexInfo IDX_MAIN2

Definition of index IDX_MAIN2.

See Also:: COL_IDX2, COL_IDX2, COL_IDX1, COL_IDX2, COL_IDX2, COL_IDX1, COL_FREEFIELD_NAME, COL_IDX2, COL_IDX2, COL_IDX1, COL_IDX2, COL_IDX2, COL_IDX1, COL_FREEFIELD_NAME, COL_DB_TABLE

INDEXES

public static final E4DBIndexInfo[] INDEXES

Definition of table indexes.

See Also:: COLUMNS

Constructor Detail

T_E4S_FREEFIELD_VAL_Sel

public T_E4S_FREEFIELD_VAL_Sel(E4DBConnection_Intf dbcon,
                               E4ApplObj_Intf applobj)

Construct an object for selecting data from T_E4S_FREEFIELD_VAL using a database connection, the table uses client distinction.

Parameters:: dbcon - a database connection; applobj - an application object, containing client and other information
See Also:: E4ModuleImplementation.getApplObj(), E4ServletImplementation_Intf.getApplObj()

T_E4S_FREEFIELD_VAL_Sel

public T_E4S_FREEFIELD_VAL_Sel(E4ApplObj_Intf applobj)
                        throws E4DBException

Construct an object for selecting data from T_E4S_FREEFIELD_VAL using the default database connection, the table uses client distinction.

Parameters:: applobj - an application object, containing client and other information
Throws:: E4DBException
See Also:: E4ModuleImplementation.getApplObj(), E4ServletImplementation_Intf.getApplObj()

T_E4S_FREEFIELD_VAL_Sel

public T_E4S_FREEFIELD_VAL_Sel(T_E4S_FREEFIELD_VAL_Sel dbtable,
                               boolean copy_where)
                        throws E4DBException

Construct an object for selecting data from T_E4S_FREEFIELD_VAL using an existing T_E4S_FREEFIELD_VAL_Sel instance.

Parameters:: dbtable - a previous created T_E4S_FREEFIELD_VAL_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_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or or()

makeInstance

public E4DBSelect_Intf makeInstance(boolean copy_where)
                             throws E4DBException

Create a new instance for T_E4S_FREEFIELD_VAL_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:: true (client distinction for this table is enabled)
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_FREEFIELD_VAL.

Specified by:: getModifyClass in interface E4DBSelect_Intf

Returns:: class for the modifications
See Also:: E4DBModify_Intf, E4DBModifyFreefields_Intf, T_E4S_FREEFIELD_VAL_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_FREEFIELD_VAL_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

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_CLIENT

public E4Client get_CLIENT()
                    throws E4DBException

Get value for client.

Returns:: the value for the client.
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_DB_TABLE

public java.lang.String get_DB_TABLE()
                              throws E4DBException

Get value for column DB_TABLE. STRING(32) Associated table

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

get_FREEFIELD_NAME

public java.lang.String get_FREEFIELD_NAME()
                                    throws E4DBException

Get value for column FREEFIELD_NAME. STRING(32) Name of the free-field

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

get_IDX1

public java.lang.String get_IDX1()
                          throws E4DBException

Get value for column IDX1. STRING(64) Index #1

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

get_IDX2

public java.lang.String get_IDX2()
                          throws E4DBException

Get value for column IDX2. STRING(64) Index #2

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

get_IDX3

public java.lang.String get_IDX3()
                          throws E4DBException

Get value for column IDX3. STRING(64) Index #3

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

get_VAL

public java.lang.String get_VAL()
                         throws E4DBException

Get value for column VAL. STRING(255) Value

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

get

public T_E4S_FREEFIELD_VAL_Obj get()
                            throws E4DBException

Get the data object for T_E4S_FREEFIELD_VAL 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_FREEFIELD_VAL_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_DB_TABLE

public void sort_DB_TABLE()

Sort ascending by column DB_TABLE. STRING(32) Associated table

sort_DB_TABLE_descending

public void sort_DB_TABLE_descending()

Sort descending by column DB_TABLE. STRING(32) Associated table

sort_FREEFIELD_NAME

public void sort_FREEFIELD_NAME()

Sort ascending by column FREEFIELD_NAME. STRING(32) Name of the free-field

sort_FREEFIELD_NAME_descending

public void sort_FREEFIELD_NAME_descending()

Sort descending by column FREEFIELD_NAME. STRING(32) Name of the free-field

sort_IDX1

public void sort_IDX1()

Sort ascending by column IDX1. STRING(64) Index #1

sort_IDX1_descending

public void sort_IDX1_descending()

Sort descending by column IDX1. STRING(64) Index #1

sort_IDX2

public void sort_IDX2()

Sort ascending by column IDX2. STRING(64) Index #2

sort_IDX2_descending

public void sort_IDX2_descending()

Sort descending by column IDX2. STRING(64) Index #2

sort_IDX3

public void sort_IDX3()

Sort ascending by column IDX3. STRING(64) Index #3

sort_IDX3_descending

public void sort_IDX3_descending()

Sort descending by column IDX3. STRING(64) Index #3

sort_VAL

public void sort_VAL()

Sort ascending by column VAL. STRING(255) Value

sort_VAL_descending

public void sort_VAL_descending()

Sort descending by column VAL. STRING(255) Value

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_DB_TABLE

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

Define a filter (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

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

where_DB_TABLE

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

Define a filter (AND-ed WHERE with operator) for column DB_TABLE. STRING(32) Associated table

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

where_DB_TABLE_in

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

Define a IN-filter (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:: E4DBException

where_DB_TABLE_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:: E4DBException

where_DB_TABLE_isNull

public void where_DB_TABLE_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:: E4DBException

where_DB_TABLE_isNotNull

public void where_DB_TABLE_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:: E4DBException

where_DB_TABLE_in

public void where_DB_TABLE_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DB_TABLE. STRING(32) Associated table

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

where_DB_TABLE_notin

public void where_DB_TABLE_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DB_TABLE. STRING(32) Associated table

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

where_DB_TABLE_isEmpty

public void where_DB_TABLE_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:: E4DBException

where_DB_TABLE_isNotEmpty

public void where_DB_TABLE_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DB_TABLE. STRING(32) Associated table

Throws:: E4DBException

where_FREEFIELD_NAME

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

Define a filter (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

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

where_FREEFIELD_NAME

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

Define a filter (AND-ed WHERE with operator) for column FREEFIELD_NAME. STRING(32) Name of the free-field

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

where_FREEFIELD_NAME_in

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

Define a IN-filter (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:: E4DBException

where_FREEFIELD_NAME_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:: E4DBException

where_FREEFIELD_NAME_isNull

public void where_FREEFIELD_NAME_isNull()
                                 throws E4DBException

Define a is-null filter (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:: E4DBException

where_FREEFIELD_NAME_isNotNull

public void where_FREEFIELD_NAME_isNotNull()
                                    throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:: E4DBException

where_FREEFIELD_NAME_in

public void where_FREEFIELD_NAME_in(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FREEFIELD_NAME. STRING(32) Name of the free-field

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

where_FREEFIELD_NAME_notin

public void where_FREEFIELD_NAME_notin(E4DBSelectDistinct filter)
                                throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) FREEFIELD_NAME. STRING(32) Name of the free-field

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

where_FREEFIELD_NAME_isEmpty

public void where_FREEFIELD_NAME_isEmpty()
                                  throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:: E4DBException

where_FREEFIELD_NAME_isNotEmpty

public void where_FREEFIELD_NAME_isNotEmpty()
                                     throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column FREEFIELD_NAME. STRING(32) Name of the free-field

Throws:: E4DBException

where_IDX1

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

Define a filter (AND-ed WHERE) for column IDX1. STRING(64) Index #1

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

where_IDX1

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

Define a filter (AND-ed WHERE with operator) for column IDX1. STRING(64) Index #1

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

where_IDX1_in

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

Define a IN-filter (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:: E4DBException

where_IDX1_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:: E4DBException

where_IDX1_isNull

public void where_IDX1_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:: E4DBException

where_IDX1_isNotNull

public void where_IDX1_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:: E4DBException

where_IDX1_in

public void where_IDX1_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX1. STRING(64) Index #1

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

where_IDX1_notin

public void where_IDX1_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX1. STRING(64) Index #1

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

where_IDX1_isEmpty

public void where_IDX1_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:: E4DBException

where_IDX1_isNotEmpty

public void where_IDX1_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX1. STRING(64) Index #1

Throws:: E4DBException

where_IDX2

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

Define a filter (AND-ed WHERE) for column IDX2. STRING(64) Index #2

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

where_IDX2

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

Define a filter (AND-ed WHERE with operator) for column IDX2. STRING(64) Index #2

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

where_IDX2_in

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

Define a IN-filter (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:: E4DBException

where_IDX2_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:: E4DBException

where_IDX2_isNull

public void where_IDX2_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:: E4DBException

where_IDX2_isNotNull

public void where_IDX2_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:: E4DBException

where_IDX2_in

public void where_IDX2_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX2. STRING(64) Index #2

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

where_IDX2_notin

public void where_IDX2_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX2. STRING(64) Index #2

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

where_IDX2_isEmpty

public void where_IDX2_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:: E4DBException

where_IDX2_isNotEmpty

public void where_IDX2_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX2. STRING(64) Index #2

Throws:: E4DBException

where_IDX3

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

Define a filter (AND-ed WHERE) for column IDX3. STRING(64) Index #3

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

where_IDX3

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

Define a filter (AND-ed WHERE with operator) for column IDX3. STRING(64) Index #3

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

where_IDX3_in

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

Define a IN-filter (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:: E4DBException

where_IDX3_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:: E4DBException

where_IDX3_isNull

public void where_IDX3_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:: E4DBException

where_IDX3_isNotNull

public void where_IDX3_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:: E4DBException

where_IDX3_in

public void where_IDX3_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX3. STRING(64) Index #3

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

where_IDX3_notin

public void where_IDX3_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) IDX3. STRING(64) Index #3

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

where_IDX3_isEmpty

public void where_IDX3_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:: E4DBException

where_IDX3_isNotEmpty

public void where_IDX3_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column IDX3. STRING(64) Index #3

Throws:: E4DBException

where_VAL

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

Define a filter (AND-ed WHERE) for column VAL. STRING(255) Value

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

where_VAL

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

Define a filter (AND-ed WHERE with operator) for column VAL. STRING(255) Value

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

where_VAL_in

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

Define a IN-filter (AND-ed WHERE) for column VAL. STRING(255) Value

Throws:: E4DBException

where_VAL_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column VAL. STRING(255) Value

Throws:: E4DBException

where_VAL_isNull

public void where_VAL_isNull()
                      throws E4DBException

Define a is-null filter (AND-ed WHERE) for column VAL. STRING(255) Value

Throws:: E4DBException

where_VAL_isNotNull

public void where_VAL_isNotNull()
                         throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column VAL. STRING(255) Value

Throws:: E4DBException

where_VAL_in

public void where_VAL_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VAL. STRING(255) Value

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

where_VAL_notin

public void where_VAL_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VAL. STRING(255) Value

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

where_VAL_isEmpty

public void where_VAL_isEmpty()
                       throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VAL. STRING(255) Value

Throws:: E4DBException

where_VAL_isNotEmpty

public void where_VAL_isNotEmpty()
                          throws E4DBException

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

Throws:: E4DBException

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,
                              E4ApplObj_Intf applobj)
                       throws E4DBException

Check, if this table contains any data.

Parameters:: con - the connection; applobj - the application object containing the Client to be checked
Throws:: E4DBException

toXml

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

Export data from database table to XML file.

Parameters:: applobj - a valid application object.; 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(E4ApplObj_Intf applobj,
                         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(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

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

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

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

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toXml

public static int toXml(E4ApplObj_Intf appobj,
                        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:: appobj - the current application object containing client informations; 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(E4ApplObj_Intf appobj,
                        java.lang.String path)
                 throws E4DBException,
                        java.io.IOException

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

Parameters:: appobj - the current application object containing client informations; path - the path for file export
Returns:: the number of records written
Throws:: E4DBException; java.io.IOException

toSql

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

Export data from database table to SQL script file.

Parameters:: applobj - a valid application object.; 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(E4ApplObj_Intf appobj,
                        java.lang.String path,
                        int include_freefields)
                 throws E4DBException,
                        java.io.IOException

Export data from database table to XML file.

Parameters:: appobj - the current application object containing client informations; 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.

findValue

public static java.lang.String findValue(E4DBTableName tablename,
                                         E4DBFreeFieldName fieldname,
                                         java.lang.String idx1,
                                         E4ApplObj_Intf applobj)
                                  throws E4DBException

Throws:: E4DBException

findValue

public static java.lang.String findValue(E4DBTableName tablename,
                                         E4DBFreeFieldName fieldname,
                                         java.lang.String idx1,
                                         java.lang.String idx2,
                                         E4ApplObj_Intf applobj)
                                  throws E4DBException

Throws:: E4DBException

findValue

public static java.lang.String findValue(E4DBTableName tablename,
                                         E4DBFreeFieldName fieldname,
                                         java.lang.String idx1,
                                         java.lang.String idx2,
                                         java.lang.String idx3,
                                         E4ApplObj_Intf applobj)
                                  throws E4DBException

Throws:: E4DBException

where_DB_TABLE

public void where_DB_TABLE(E4DBTableName tablename)
                    throws E4DBException

Throws:: E4DBException

where_FREEFIELD_NAME

public void where_FREEFIELD_NAME(E4DBFreeFieldName fieldname)
                          throws E4DBException

Throws:: E4DBException

where_FREEFIELD_NAME_in

public void where_FREEFIELD_NAME_in(E4DBFreeFieldName[] freefields)
                             throws E4DBException

Throws:: E4DBException

where_IDX1

public void where_IDX1(long val)
                throws E4DBException

Throws:: E4DBException

where_IDX1

public void where_IDX1(E4Long val)
                throws E4DBException

Throws:: E4DBException

where_IDX1

public void where_IDX1(int val)
                throws E4DBException

Throws:: E4DBException

where_IDX1

public void where_IDX1(double val)
                throws E4DBException

Throws:: E4DBException

where_IDX1

public void where_IDX1(boolean val)
                throws E4DBException

Throws:: E4DBException

where_IDX1

public void where_IDX1(java.util.Date val)
                throws E4DBException

Throws:: E4DBException

where_IDX1

public void where_IDX1(E4String val)
                throws E4DBException

Throws:: E4DBException

where_IDX2

public void where_IDX2(long val)
                throws E4DBException

Throws:: E4DBException

where_IDX2

public void where_IDX2(E4Long val)
                throws E4DBException

Throws:: E4DBException

where_IDX2

public void where_IDX2(int val)
                throws E4DBException

Throws:: E4DBException

where_IDX2

public void where_IDX2(double val)
                throws E4DBException

Throws:: E4DBException

where_IDX2

public void where_IDX2(boolean val)
                throws E4DBException

Throws:: E4DBException

where_IDX2

public void where_IDX2(java.util.Date val)
                throws E4DBException

Throws:: E4DBException

where_IDX2

public void where_IDX2(E4String val)
                throws E4DBException

Throws:: E4DBException

where_IDX3

public void where_IDX3(long val)
                throws E4DBException

Throws:: E4DBException

where_IDX3

public void where_IDX3(E4Long val)
                throws E4DBException

Throws:: E4DBException

where_IDX3

public void where_IDX3(int val)
                throws E4DBException

Throws:: E4DBException

where_IDX3

public void where_IDX3(double val)
                throws E4DBException

Throws:: E4DBException

where_IDX3

public void where_IDX3(boolean val)
                throws E4DBException

Throws:: E4DBException

where_IDX3

public void where_IDX3(java.util.Date val)
                throws E4DBException

Throws:: E4DBException

where_IDX3

public void where_IDX3(E4String val)
                throws E4DBException

Throws:: E4DBException

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_FREEFIELD_VAL_Sel

TABLENAME

SVN_REVISION

IS_CLIENT_DISTINCTIVE

IS_FREEDEF_POSSIBLE

COL_DATMOD

CI_DATMOD

COL_DATNEW

CI_DATNEW

COL_DB_TABLE

CI_DB_TABLE

COL_FREEFIELD_NAME

CI_FREEFIELD_NAME

COL_IDX1

CI_IDX1

COL_IDX2

CI_IDX2

COL_IDX3

CI_IDX3

COL_VAL

CI_VAL

COLUMNS

IDX_MAIN3

IDX_FIELD

IDX_MAIN1

IDX_MAIN2

INDEXES

T_E4S_FREEFIELD_VAL_Sel

T_E4S_FREEFIELD_VAL_Sel

T_E4S_FREEFIELD_VAL_Sel

or

makeInstance

E4ID

hasClientDistinctive

canHaveFreeDefinedFields

getModifyClass

makeInstance_Modify

getObjectClass

getColInfo

getIdxInfo

next

get_CLIENT

get_DATMOD

get_DATNEW

get_DB_TABLE

get_FREEFIELD_NAME

get_IDX1

get_IDX2

get_IDX3

get_VAL

get

getQuery

sort_DATMOD

sort_DATMOD_descending

sort_DATNEW

sort_DATNEW_descending

sort_DB_TABLE

sort_DB_TABLE_descending

sort_FREEFIELD_NAME

sort_FREEFIELD_NAME_descending

sort_IDX1

sort_IDX1_descending

sort_IDX2

sort_IDX2_descending

sort_IDX3

sort_IDX3_descending

sort_VAL

sort_VAL_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

where_DATNEW

where_DATNEW_isNull

where_DATNEW_isNotNull

e4s.db.systabledef
Class T_E4S_FREEFIELD_VAL_Sel