e4s.db.systabledef
Class T_E4S_CLIENT_Sel

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

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterAnd_Intf, E4DBSelect_Intf

public class T_E4S_CLIENT_Sel
extends E4DBSelect
implements E4DBSelect_Intf

SQL select for T_E4S_CLIENT: This table hold the core client information, which is the fundament for all subsequent client distinctions. created: 20041111 042740, modified: 20071103 125915. $LastChangedRevision: 5290 $ $LastChangedDate: 2009-12-09 18:45:55 +0100 (Mi, 09 Dez 2009) $

Column	Datatype		Remark
BELONGS_TO	STRING(16)		Client, to whom this record belongs, can be empty/null
CLIENT_ID	STRING(16)	1	ID of the client (primary key)
COUNTRY	CountryCode		Countrycode
DATMOD	DATE		Date of modification
DATNEW	DATE		Date of creation
DECIMALSIGN	E4DecimalSign STRING(1)		Default decimal sign (but user overridden)
LOGO	E4ClientLogo STRING(128)		Associated Logo for the client
MAIN_COMPANY_ID	E4CompanyId INTEGER		Main Company
NAME	STRING(40)		Name of this client
VALID_UNTIL	DATE		Date, until this client is valid

Index 1: CLIENT_ID unique

See Also:

T_E4S_CLIENT_Mod, T_E4S_CLIENT_Obj

Nested Class Summary

static class	T_E4S_CLIENT_Sel.T_E4S_CLIENT_And Filter to be used as AND condition.
static class	T_E4S_CLIENT_Sel.T_E4S_CLIENT_Or Filter to be used as OR condition.

Field Summary

static E4DBColumnInfo	CI_BELONGS_TO
static E4DBColumnInfo	CI_CLIENT_ID
static E4DBColumnInfo	CI_COUNTRY
static E4DBColumnInfo	CI_DATMOD
static E4DBColumnInfo	CI_DATNEW
static E4DBColumnInfo	CI_DECIMALSIGN
static E4DBColumnInfo	CI_LOGO
static E4DBColumnInfo	CI_MAIN_COMPANY_ID
static E4DBColumnInfo	CI_NAME
static E4DBColumnInfo	CI_VALID_UNTIL
static E4DBColumnName	COL_BELONGS_TO STRING(16) Client, to whom this record belongs, can be empty/null
static E4DBColumnName	COL_CLIENT_ID STRING(16) ID of the client (primary key) Member of index: CLIENT_ID.
static E4DBColumnName	COL_COUNTRY CountryCode Countrycode
static E4DBColumnName	COL_DATMOD DATE Date of modification
static E4DBColumnName	COL_DATNEW DATE Date of creation
static E4DBColumnName	COL_DECIMALSIGN E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)
static E4DBColumnName	COL_LOGO E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client
static E4DBColumnName	COL_MAIN_COMPANY_ID E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Main Company
static E4DBColumnName	COL_NAME STRING(40) Name of this client
static E4DBColumnName	COL_VALID_UNTIL DATE Date, until this client is valid
static E4DBColumnInfo[]	COLUMNS Definition of database columns as array
static E4DBIndexInfo	IDX_CLIENT_ID Definition of index IDX_CLIENT_ID.
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_CLIENT_Sel()
Construct an object for selecting data from T_E4S_CLIENT using the default database connection.

T_E4S_CLIENT_Sel(E4DBConnection_Intf dbcon)
Construct an object for selecting data from T_E4S_CLIENT using a database connection.

T_E4S_CLIENT_Sel(T_E4S_CLIENT_Sel dbtable, boolean copy_where)
Construct an object for selecting data from T_E4S_CLIENT using an existing T_E4S_CLIENT_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_CLIENT_Obj	find_CLIENT_ID(E4Client client)
static T_E4S_CLIENT_Obj	find_CLIENT_ID(E4DBConnection_Intf con, java.lang.String qCLIENT_ID) Find a record associates with index 1 (CLIENT_ID).
static T_E4S_CLIENT_Obj	find_CLIENT_ID(java.lang.String qCLIENT_ID) Find a record associates with unique index 1 (CLIENT_ID).
java.lang.String	get_BELONGS_TO() Get value for column BELONGS_TO.
java.lang.String	get_CLIENT_ID() Get value for column CLIENT_ID.
E4Client	get_CLIENT()
CountryCode	get_COUNTRY() Get value for column COUNTRY.
java.util.Date	get_DATMOD() Get value for column DATMOD.
java.util.Date	get_DATNEW() Get value for column DATNEW.
E4DecimalSign	get_DECIMALSIGN() Get value for column DECIMALSIGN.
E4Fieldset	get_FIELDSET()
E4Fieldset	get_FIELDSET(FORM form)
E4ClientLogo	get_LOGO() Get value for column LOGO.
E4CompanyId	get_MAIN_COMPANY_ID() Get value for column MAIN_COMPANY_ID.
java.lang.String	get_NAME() Get value for column NAME.
java.util.Date	get_VALID_UNTIL() Get value for column VALID_UNTIL.
T_E4S_CLIENT_Obj	get() Get the data object for T_E4S_CLIENT without reading freedefined values.
void	get(E4Fieldset fieldset)
static E4Client[]	getClients() Get an array of all clients defined
E4DBColumnInfo[]	getColInfo() Get information about the columns defined for this database table.
E4DBIndexInfo	getFirstPrimaryIndex() Get the fields defined for the first unique index IDX_CLIENT_ID.
static E4Client	getFreeClient()
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_CLIENT.
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_CLIENT_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_CLIENT_Sel
boolean	next() Fetch next record.
T_E4S_CLIENT_Sel.T_E4S_CLIENT_Or	or()
void	sort_BELONGS_TO_descending() Sort descending by column BELONGS_TO.
void	sort_BELONGS_TO() Sort ascending by column BELONGS_TO.
void	sort_CLIENT_ID_descending() Sort descending by column CLIENT_ID.
void	sort_CLIENT_ID() Sort ascending by column CLIENT_ID.
void	sort_COUNTRY_descending() Sort descending by column COUNTRY.
void	sort_COUNTRY() Sort ascending by column COUNTRY.
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_DECIMALSIGN_descending() Sort descending by column DECIMALSIGN.
void	sort_DECIMALSIGN() Sort ascending by column DECIMALSIGN.
void	sort_LOGO_descending() Sort descending by column LOGO.
void	sort_LOGO() Sort ascending by column LOGO.
void	sort_MAIN_COMPANY_ID_descending() Sort descending by column MAIN_COMPANY_ID.
void	sort_MAIN_COMPANY_ID() Sort ascending by column MAIN_COMPANY_ID.
void	sort_NAME_descending() Sort descending by column NAME.
void	sort_NAME() Sort ascending by column NAME.
void	sort_VALID_UNTIL_descending() Sort descending by column VALID_UNTIL.
void	sort_VALID_UNTIL() Sort ascending by column VALID_UNTIL.
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_BELONGS_TO_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_BELONGS_TO_in(java.lang.String[] filter) Define a IN-filter (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_isNull() Define a is-null filter (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_not_in(java.lang.String[] filter) Define a NOT-IN-filter (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_BELONGS_TO(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column BELONGS_TO.
void	where_BELONGS_TO(java.lang.String filter) Define a filter (AND-ed WHERE) for column BELONGS_TO.
void	where_CLIENT_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_CLIENT_ID_in(java.lang.String[] filter) Define a IN-filter (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_isNull() Define a is-null filter (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_not_in(java.lang.String[] filter) Define a NOT-IN-filter (AND-ed WHERE) for column CLIENT_ID.
void	where_CLIENT_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_CLIENT_ID(E4Client client)
void	where_CLIENT_ID(int operator, E4Client client)
void	where_CLIENT_ID(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column CLIENT_ID.
void	where_CLIENT_ID(java.lang.String filter) Define a filter (AND-ed WHERE) for column CLIENT_ID.
void	where_COUNTRY_in(CountryCode[] filter) Define a IN-filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COUNTRY_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_isNull() Define a is-null filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_not_in(CountryCode[] filter) Define a NOT-IN-filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COUNTRY(CountryCode filter) Define a filter (AND-ed WHERE) for column COUNTRY.
void	where_COUNTRY(int operator, CountryCode filter) Define a filter (AND-ed WHERE with operator) for column COUNTRY.
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_DECIMALSIGN_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DECIMALSIGN_in(E4DecimalSign[] filter) Define a IN-filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_isNull() Define a is-null filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_not_in(E4DecimalSign[] filter) Define a NOT-IN-filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DECIMALSIGN(E4DecimalSign filter) Define a filter (AND-ed WHERE) for column DECIMALSIGN.
void	where_DECIMALSIGN(int operator, E4DecimalSign filter) Define a filter (AND-ed WHERE with operator) for column DECIMALSIGN.
void	where_LOGO_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGO_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGO.
void	where_LOGO_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGO.
void	where_LOGO_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column LOGO.
void	where_LOGO_isNull() Define a is-null filter (AND-ed WHERE) for column LOGO.
void	where_LOGO_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGO(E4ClientLogo filter) Define a filter (AND-ed WHERE) for column LOGO.
void	where_LOGO(int operator, E4ClientLogo filter) Define a filter (AND-ed WHERE with operator) for column LOGO.
void	where_MAIN_COMPANY_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_MAIN_COMPANY_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_MAIN_COMPANY_ID(E4CompanyId filter) Define a filter (AND-ed WHERE) for column MAIN_COMPANY_ID.
void	where_MAIN_COMPANY_ID(int operator, E4CompanyId filter) Define a filter (AND-ed WHERE with operator) for column MAIN_COMPANY_ID.
void	where_NAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_NAME_in(java.lang.String[] filter) Define a IN-filter (AND-ed WHERE) for column NAME.
void	where_NAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
void	where_NAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME.
void	where_NAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column NAME.
void	where_NAME_isNull() Define a is-null filter (AND-ed WHERE) for column NAME.
void	where_NAME_not_in(java.lang.String[] filter) Define a NOT-IN-filter (AND-ed WHERE) for column NAME.
void	where_NAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_NAME(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column NAME.
void	where_NAME(java.lang.String filter) Define a filter (AND-ed WHERE) for column NAME.
void	where_VALID_UNTIL_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_VALID_UNTIL_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL_isNull() Define a is-null filter (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_VALID_UNTIL(java.util.Date filter) Define a filter (AND-ed WHERE) for column VALID_UNTIL.
void	where_VALID_UNTIL(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column VALID_UNTIL.

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.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 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, 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_BELONGS_TO

public static final E4DBColumnName COL_BELONGS_TO

STRING(16) Client, to whom this record belongs, can be empty/null

CI_BELONGS_TO

public static final E4DBColumnInfo CI_BELONGS_TO

COL_CLIENT_ID

public static final E4DBColumnName COL_CLIENT_ID

STRING(16) ID of the client (primary key) Member of index: CLIENT_ID.

See Also:

IDX_CLIENT_ID

CI_CLIENT_ID

public static final E4DBColumnInfo CI_CLIENT_ID

COL_COUNTRY

public static final E4DBColumnName COL_COUNTRY

CountryCode Countrycode

CI_COUNTRY

public static final E4DBColumnInfo CI_COUNTRY

COL_DATMOD

public static final E4DBColumnName COL_DATMOD

DATE Date of modification

CI_DATMOD

public static final E4DBColumnInfo CI_DATMOD

COL_DATNEW

public static final E4DBColumnName COL_DATNEW

DATE Date of creation

CI_DATNEW

public static final E4DBColumnInfo CI_DATNEW

COL_DECIMALSIGN

public static final E4DBColumnName COL_DECIMALSIGN

E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

See Also:

E4DecimalSign

CI_DECIMALSIGN

public static final E4DBColumnInfo CI_DECIMALSIGN

COL_LOGO

public static final E4DBColumnName COL_LOGO

E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

See Also:

E4ClientLogo

CI_LOGO

public static final E4DBColumnInfo CI_LOGO

COL_MAIN_COMPANY_ID

public static final E4DBColumnName COL_MAIN_COMPANY_ID

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

See Also:

E4CompanyId

CI_MAIN_COMPANY_ID

public static final E4DBColumnInfo CI_MAIN_COMPANY_ID

COL_NAME

public static final E4DBColumnName COL_NAME

STRING(40) Name of this client

CI_NAME

public static final E4DBColumnInfo CI_NAME

COL_VALID_UNTIL

public static final E4DBColumnName COL_VALID_UNTIL

DATE Date, until this client is valid

CI_VALID_UNTIL

public static final E4DBColumnInfo CI_VALID_UNTIL

COLUMNS

public static final E4DBColumnInfo[] COLUMNS

Definition of database columns as array

See Also:

INDEXES

IDX_CLIENT_ID

public static final E4DBIndexInfo IDX_CLIENT_ID

Definition of index IDX_CLIENT_ID.

See Also:

COL_CLIENT_ID

INDEXES

public static final E4DBIndexInfo[] INDEXES

Definition of table indexes.

See Also:

COLUMNS

Constructor Detail

T_E4S_CLIENT_Sel

public T_E4S_CLIENT_Sel(E4DBConnection_Intf dbcon)

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

Parameters:

dbcon - a database connection

T_E4S_CLIENT_Sel

public T_E4S_CLIENT_Sel()
                 throws E4DBException

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

Throws:

E4DBException

T_E4S_CLIENT_Sel

public T_E4S_CLIENT_Sel(T_E4S_CLIENT_Sel dbtable,
                        boolean copy_where)
                 throws E4DBException

Construct an object for selecting data from T_E4S_CLIENT using an existing T_E4S_CLIENT_Sel instance.

Parameters:

dbtable - a previous created T_E4S_CLIENT_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_CLIENT_Sel.T_E4S_CLIENT_Or or()

makeInstance

public E4DBSelect_Intf makeInstance(boolean copy_where)
                             throws E4DBException

Create a new instance for T_E4S_CLIENT_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_CLIENT.

Specified by:

getModifyClass in interface E4DBSelect_Intf

Returns:

class for the modifications

See Also:

E4DBModify_Intf, E4DBModifyFreefields_Intf, T_E4S_CLIENT_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_CLIENT_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_CLIENT_ID.

Specified by:

getFirstPrimaryIndex in interface E4DBSelect_Intf

Overrides:

getFirstPrimaryIndex in class E4DBSelect

Returns:

IDX_CLIENT_ID.

next

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_BELONGS_TO

public java.lang.String get_BELONGS_TO()
                                throws E4DBException

Get value for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Returns:

the database column value retrieved for field BELONGS_TO

Throws:

E4DBException

get_CLIENT_ID

public java.lang.String get_CLIENT_ID()
                               throws E4DBException

Get value for column CLIENT_ID. STRING(16) ID of the client (primary key)

Returns:

the database column value retrieved for field CLIENT_ID

Throws:

E4DBException

get_COUNTRY

public CountryCode get_COUNTRY()
                        throws E4DBException

Get value for column COUNTRY. CountryCode Countrycode

Returns:

the database column value retrieved for field COUNTRY

Throws:

E4DBException

get_DATMOD

public java.util.Date get_DATMOD()
                          throws E4DBException

Get value for column DATMOD. DATE Date of modification

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 of creation

Returns:

the database column value retrieved for field DATNEW

Throws:

E4DBException

get_DECIMALSIGN

public E4DecimalSign get_DECIMALSIGN()
                              throws E4DBException

Get value for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Returns:

the database column value retrieved for field DECIMALSIGN

Throws:

E4DBException

See Also:

E4DecimalSign

get_LOGO

public E4ClientLogo get_LOGO()
                      throws E4DBException

Get value for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Returns:

the database column value retrieved for field LOGO

Throws:

E4DBException

See Also:

E4ClientLogo

get_MAIN_COMPANY_ID

public E4CompanyId get_MAIN_COMPANY_ID()
                                throws E4DBException

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

Returns:

the database column value retrieved for field MAIN_COMPANY_ID

Throws:

E4DBException

See Also:

E4CompanyId

get_NAME

public java.lang.String get_NAME()
                          throws E4DBException

Get value for column NAME. STRING(40) Name of this client

Returns:

the database column value retrieved for field NAME

Throws:

E4DBException

get_VALID_UNTIL

public java.util.Date get_VALID_UNTIL()
                               throws E4DBException

Get value for column VALID_UNTIL. DATE Date, until this client is valid

Returns:

the database column value retrieved for field VALID_UNTIL

Throws:

E4DBException

get

public T_E4S_CLIENT_Obj get()
                     throws E4DBException

Get the data object for T_E4S_CLIENT 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_CLIENT_Obj in a Vector. Perform a E4DBSelect.close() afterwards.

Throws:

E4DBException

sort_BELONGS_TO

public void sort_BELONGS_TO()

Sort ascending by column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

sort_BELONGS_TO_descending

public void sort_BELONGS_TO_descending()

Sort descending by column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

sort_CLIENT_ID

public void sort_CLIENT_ID()

Sort ascending by column CLIENT_ID. STRING(16) ID of the client (primary key)

sort_CLIENT_ID_descending

public void sort_CLIENT_ID_descending()

Sort descending by column CLIENT_ID. STRING(16) ID of the client (primary key)

sort_COUNTRY

public void sort_COUNTRY()

Sort ascending by column COUNTRY. CountryCode Countrycode

sort_COUNTRY_descending

public void sort_COUNTRY_descending()

Sort descending by column COUNTRY. CountryCode Countrycode

sort_DATMOD

public void sort_DATMOD()

Sort ascending by column DATMOD. DATE Date of modification

sort_DATMOD_descending

public void sort_DATMOD_descending()

Sort descending by column DATMOD. DATE Date of modification

sort_DATNEW

public void sort_DATNEW()

Sort ascending by column DATNEW. DATE Date of creation

sort_DATNEW_descending

public void sort_DATNEW_descending()

Sort descending by column DATNEW. DATE Date of creation

sort_DECIMALSIGN

public void sort_DECIMALSIGN()

Sort ascending by column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

See Also:

E4DecimalSign

sort_DECIMALSIGN_descending

public void sort_DECIMALSIGN_descending()

Sort descending by column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

See Also:

E4DecimalSign

sort_LOGO

public void sort_LOGO()

Sort ascending by column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

See Also:

E4ClientLogo

sort_LOGO_descending

public void sort_LOGO_descending()

Sort descending by column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

See Also:

E4ClientLogo

sort_MAIN_COMPANY_ID

public void sort_MAIN_COMPANY_ID()

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

See Also:

E4CompanyId

sort_MAIN_COMPANY_ID_descending

public void sort_MAIN_COMPANY_ID_descending()

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

See Also:

E4CompanyId

sort_NAME

public void sort_NAME()

Sort ascending by column NAME. STRING(40) Name of this client

sort_NAME_descending

public void sort_NAME_descending()

Sort descending by column NAME. STRING(40) Name of this client

sort_VALID_UNTIL

public void sort_VALID_UNTIL()

Sort ascending by column VALID_UNTIL. DATE Date, until this client is valid

sort_VALID_UNTIL_descending

public void sort_VALID_UNTIL_descending()

Sort descending by column VALID_UNTIL. DATE Date, until this client is valid

where_BELONGS_TO

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

Define a filter (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_BELONGS_TO

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

Define a filter (AND-ed WHERE with operator) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_BELONGS_TO_in

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

Define a IN-filter (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_BELONGS_TO_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_BELONGS_TO_isNull

public void where_BELONGS_TO_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_BELONGS_TO_isNotNull

public void where_BELONGS_TO_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_BELONGS_TO_in

public void where_BELONGS_TO_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_BELONGS_TO_notin

public void where_BELONGS_TO_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_BELONGS_TO_isEmpty

public void where_BELONGS_TO_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_BELONGS_TO_isNotEmpty

public void where_BELONGS_TO_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column BELONGS_TO. STRING(16) Client, to whom this record belongs, can be empty/null

Throws:

E4DBException

where_CLIENT_ID

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

Define a filter (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CLIENT_ID

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

Define a filter (AND-ed WHERE with operator) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_CLIENT_ID_in

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

Define a IN-filter (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_CLIENT_ID_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_CLIENT_ID_isNull

public void where_CLIENT_ID_isNull()
                            throws E4DBException

Define a is-null filter (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_CLIENT_ID_isNotNull

public void where_CLIENT_ID_isNotNull()
                               throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_CLIENT_ID_in

public void where_CLIENT_ID_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CLIENT_ID. STRING(16) ID of the client (primary key)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CLIENT_ID_notin

public void where_CLIENT_ID_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CLIENT_ID. STRING(16) ID of the client (primary key)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CLIENT_ID_isEmpty

public void where_CLIENT_ID_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_CLIENT_ID_isNotEmpty

public void where_CLIENT_ID_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CLIENT_ID. STRING(16) ID of the client (primary key)

Throws:

E4DBException

where_COUNTRY

public void where_COUNTRY(CountryCode filter)
                   throws E4DBException

Define a filter (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRY

public void where_COUNTRY(int operator,
                          CountryCode filter)
                   throws E4DBException

Define a filter (AND-ed WHERE with operator) for column COUNTRY. CountryCode Countrycode

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_COUNTRY_like

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

Define a filter (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRY_in

public void where_COUNTRY_in(CountryCode[] filter)
                      throws E4DBException

Define a IN-filter (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_COUNTRY_not_in

public void where_COUNTRY_not_in(CountryCode[] filter)
                          throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_COUNTRY_isNull

public void where_COUNTRY_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_COUNTRY_isNotNull

public void where_COUNTRY_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_COUNTRY_in

public void where_COUNTRY_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COUNTRY. CountryCode Countrycode

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRY_notin

public void where_COUNTRY_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COUNTRY. CountryCode Countrycode

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRY_isEmpty

public void where_COUNTRY_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_COUNTRY_isNotEmpty

public void where_COUNTRY_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRY. CountryCode Countrycode

Throws:

E4DBException

where_DATMOD

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

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

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 of modification

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 of modification

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 of modification

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 of modification

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 of modification

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 of modification

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 of modification

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 of creation

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 of creation

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 of creation

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 of creation

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 of creation

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 of creation

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 of creation

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 of creation

Throws:

E4DBException

where_DECIMALSIGN

public void where_DECIMALSIGN(E4DecimalSign filter)
                       throws E4DBException

Define a filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN

public void where_DECIMALSIGN(int operator,
                              E4DecimalSign filter)
                       throws E4DBException

Define a filter (AND-ed WHERE with operator) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_like

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

Define a filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_in

public void where_DECIMALSIGN_in(E4DecimalSign[] filter)
                          throws E4DBException

Define a IN-filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_not_in

public void where_DECIMALSIGN_not_in(E4DecimalSign[] filter)
                              throws E4DBException

Define a NOT-IN-filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_isNull

public void where_DECIMALSIGN_isNull()
                              throws E4DBException

Define a is-null filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_isNotNull

public void where_DECIMALSIGN_isNotNull()
                                 throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_in

public void where_DECIMALSIGN_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_notin

public void where_DECIMALSIGN_notin(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_isEmpty

public void where_DECIMALSIGN_isEmpty()
                               throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Throws:

E4DBException

See Also:

E4DecimalSign

where_DECIMALSIGN_isNotEmpty

public void where_DECIMALSIGN_isNotEmpty()
                                  throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DECIMALSIGN. E4DecimalSign defined as e4s.util.E4String(1) Definition for Decimal Sign, related to Client/User Default decimal sign (but user overridden)

Throws:

E4DBException

See Also:

E4DecimalSign

where_LOGO

public void where_LOGO(E4ClientLogo filter)
                throws E4DBException

Define a filter (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO

public void where_LOGO(int operator,
                       E4ClientLogo filter)
                throws E4DBException

Define a filter (AND-ed WHERE with operator) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_isNull

public void where_LOGO_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_isNotNull

public void where_LOGO_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_in

public void where_LOGO_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_notin

public void where_LOGO_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_isEmpty

public void where_LOGO_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Throws:

E4DBException

See Also:

E4ClientLogo

where_LOGO_isNotEmpty

public void where_LOGO_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGO. E4ClientLogo defined as e4s.util.E4StringImage(128) Image (Company Logo) for Client Associated Logo for the client

Throws:

E4DBException

See Also:

E4ClientLogo

where_MAIN_COMPANY_ID

public void where_MAIN_COMPANY_ID(E4CompanyId filter)
                           throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_MAIN_COMPANY_ID

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyId

where_MAIN_COMPANY_ID_in

public void where_MAIN_COMPANY_ID_in(E4DBSelectDistinct filter)
                              throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_MAIN_COMPANY_ID_notin

public void where_MAIN_COMPANY_ID_notin(E4DBSelectDistinct filter)
                                 throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_NAME

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

Define a filter (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_NAME

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

Define a filter (AND-ed WHERE with operator) for column NAME. STRING(40) Name of this client

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_NAME_in

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

Define a IN-filter (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_NAME_not_in

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

Define a NOT-IN-filter (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_NAME_isNull

public void where_NAME_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_NAME_isNotNull

public void where_NAME_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_NAME_in

public void where_NAME_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME. STRING(40) Name of this client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_NAME_notin

public void where_NAME_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) NAME. STRING(40) Name of this client

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_NAME_isEmpty

public void where_NAME_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_NAME_isNotEmpty

public void where_NAME_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column NAME. STRING(40) Name of this client

Throws:

E4DBException

where_VALID_UNTIL

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

Define a filter (AND-ed WHERE) for column VALID_UNTIL. DATE Date, until this client is valid

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VALID_UNTIL

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

Define a filter (AND-ed WHERE with operator) for column VALID_UNTIL. DATE Date, until this client is valid

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_VALID_UNTIL_isNull

public void where_VALID_UNTIL_isNull()
                              throws E4DBException

Define a is-null filter (AND-ed WHERE) for column VALID_UNTIL. DATE Date, until this client is valid

Throws:

E4DBException

where_VALID_UNTIL_isNotNull

public void where_VALID_UNTIL_isNotNull()
                                 throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column VALID_UNTIL. DATE Date, until this client is valid

Throws:

E4DBException

where_VALID_UNTIL_in

public void where_VALID_UNTIL_in(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL. DATE Date, until this client is valid

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VALID_UNTIL_notin

public void where_VALID_UNTIL_notin(E4DBSelectDistinct filter)
                             throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) VALID_UNTIL. DATE Date, until this client is valid

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_VALID_UNTIL_isEmpty

public void where_VALID_UNTIL_isEmpty()
                               throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL. DATE Date, until this client is valid

Throws:

E4DBException

where_VALID_UNTIL_isNotEmpty

public void where_VALID_UNTIL_isNotEmpty()
                                  throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column VALID_UNTIL. DATE Date, until this client is valid

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)
                       throws E4DBException

Check, if this table contains any data.

Parameters:

con - the connection

Throws:

E4DBException

find_CLIENT_ID

public static T_E4S_CLIENT_Obj find_CLIENT_ID(java.lang.String qCLIENT_ID)
                                       throws E4DBException

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

Parameters:

qCLIENT_ID - query ID of the client (primary key)

Throws:

E4DBException

find_CLIENT_ID

public static T_E4S_CLIENT_Obj find_CLIENT_ID(E4DBConnection_Intf con,
                                              java.lang.String qCLIENT_ID)
                                       throws E4DBException

Find a record associates with index 1 (CLIENT_ID).

Parameters:

con - the database connection

qCLIENT_ID - query ID of the client (primary key)

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.

get_CLIENT

public E4Client get_CLIENT()
                    throws E4DBException

Throws:

E4DBException

where_CLIENT_ID

public void where_CLIENT_ID(E4Client client)
                     throws E4DBException

Throws:

E4DBException

where_CLIENT_ID

public void where_CLIENT_ID(int operator,
                            E4Client client)
                     throws E4DBException

Throws:

E4DBException

find_CLIENT_ID

public static T_E4S_CLIENT_Obj find_CLIENT_ID(E4Client client)
                                       throws E4DBException

Throws:

E4DBException

getClients

public static E4Client[] getClients()
                             throws E4DBException

Get an array of all clients defined

Throws:

E4DBException

getFreeClient

public static E4Client getFreeClient()
                              throws E4DBException

Throws:

E4DBException