e4s.db.systabledef
Class T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr
              e4s.db.systabledef.T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Enclosing class:

T_E4S_COMPANY_Sel

public static class T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or
extends E4DBFilterOr
implements E4DBFilter_Intf

Filter to be used as OR condition.

Field Summary

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_COMPANY_Sel.T_E4S_COMPANY_Or()

Method Summary

T_E4S_COMPANY_Sel.T_E4S_COMPANY_And	and()
void	where_ADDRESS01_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ADDRESS01_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01.
void	where_ADDRESS01_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01.
void	where_ADDRESS01_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS01.
void	where_ADDRESS01_isNull() Define a is-null filter (AND-ed WHERE) for column ADDRESS01.
void	where_ADDRESS01_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ADDRESS01(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column ADDRESS01.
void	where_ADDRESS01(java.lang.String filter) Define a filter (AND-ed WHERE) for column ADDRESS01.
void	where_ADDRESS02_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ADDRESS02_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02.
void	where_ADDRESS02_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02.
void	where_ADDRESS02_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS02.
void	where_ADDRESS02_isNull() Define a is-null filter (AND-ed WHERE) for column ADDRESS02.
void	where_ADDRESS02_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ADDRESS02(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column ADDRESS02.
void	where_ADDRESS02(java.lang.String filter) Define a filter (AND-ed WHERE) for column ADDRESS02.
void	where_BELONGS_TO_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_BELONGS_TO_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_BELONGS_TO(E4CompanyId filter) Define a filter (AND-ed WHERE) for column BELONGS_TO.
void	where_BELONGS_TO(int operator, E4CompanyId filter) Define a filter (AND-ed WHERE with operator) for column BELONGS_TO.
void	where_CITY_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_CITY_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY.
void	where_CITY_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY.
void	where_CITY_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column CITY.
void	where_CITY_isNull() Define a is-null filter (AND-ed WHERE) for column CITY.
void	where_CITY_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_CITY(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column CITY.
void	where_CITY(java.lang.String filter) Define a filter (AND-ed WHERE) for column CITY.
void	where_COMPANY_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COMPANY_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COMPANY_ID(E4CompanyId filter) Define a filter (AND-ed WHERE) for column COMPANY_ID.
void	where_COMPANY_ID(int operator, E4CompanyId filter) Define a filter (AND-ed WHERE with operator) for column COMPANY_ID.
void	where_COUNTRYCODE_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COUNTRYCODE_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRYCODE.
void	where_COUNTRYCODE_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRYCODE.
void	where_COUNTRYCODE_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column COUNTRYCODE.
void	where_COUNTRYCODE_isNull() Define a is-null filter (AND-ed WHERE) for column COUNTRYCODE.
void	where_COUNTRYCODE_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column COUNTRYCODE.
void	where_COUNTRYCODE_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_COUNTRYCODE(CountryCode filter) Define a filter (AND-ed WHERE) for column COUNTRYCODE.
void	where_COUNTRYCODE(int operator, CountryCode filter) Define a filter (AND-ed WHERE with operator) for column COUNTRYCODE.
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_EMAIL_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_EMAIL_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
void	where_EMAIL_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL.
void	where_EMAIL_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL.
void	where_EMAIL_isNull() Define a is-null filter (AND-ed WHERE) for column EMAIL.
void	where_EMAIL_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_EMAIL(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column EMAIL.
void	where_EMAIL(java.lang.String filter) Define a filter (AND-ed WHERE) for column EMAIL.
void	where_GIS_LATITUDE(float filter) Define a filter (AND-ed WHERE) for column GIS_LATITUDE.
void	where_GIS_LATITUDE(int operator, float filter) Define a filter (AND-ed WHERE with operator) for column GIS_LATITUDE.
void	where_GIS_LONGITUDE(float filter) Define a filter (AND-ed WHERE) for column GIS_LONGITUDE.
void	where_GIS_LONGITUDE(int operator, float filter) Define a filter (AND-ed WHERE with operator) for column GIS_LONGITUDE.
void	where_GROUP_ID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_GROUP_ID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID.
void	where_GROUP_ID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID.
void	where_GROUP_ID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column GROUP_ID.
void	where_GROUP_ID_isNull() Define a is-null filter (AND-ed WHERE) for column GROUP_ID.
void	where_GROUP_ID_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column GROUP_ID.
void	where_GROUP_ID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_GROUP_ID(E4CompanyGroup filter) Define a filter (AND-ed WHERE) for column GROUP_ID.
void	where_GROUP_ID(int operator, E4CompanyGroup filter) Define a filter (AND-ed WHERE with operator) for column GROUP_ID.
void	where_LOGIN_NAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGIN_NAME_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_isNull() Define a is-null filter (AND-ed WHERE) for column LOGIN_NAME.
void	where_LOGIN_NAME_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_LOGIN_NAME(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME.
void	where_LOGIN_NAME(java.lang.String filter) Define a filter (AND-ed WHERE) for column LOGIN_NAME.
void	where_NAME_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
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_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_PHONE01_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_PHONE01_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01.
void	where_PHONE01_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01.
void	where_PHONE01_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column PHONE01.
void	where_PHONE01_isNull() Define a is-null filter (AND-ed WHERE) for column PHONE01.
void	where_PHONE01_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_PHONE01(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column PHONE01.
void	where_PHONE01(java.lang.String filter) Define a filter (AND-ed WHERE) for column PHONE01.
void	where_PHONE02_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_PHONE02_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02.
void	where_PHONE02_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02.
void	where_PHONE02_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column PHONE02.
void	where_PHONE02_isNull() Define a is-null filter (AND-ed WHERE) for column PHONE02.
void	where_PHONE02_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_PHONE02(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column PHONE02.
void	where_PHONE02(java.lang.String filter) Define a filter (AND-ed WHERE) for column PHONE02.
void	where_REM_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_REM_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
void	where_REM_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column REM.
void	where_REM_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column REM.
void	where_REM_isNull() Define a is-null filter (AND-ed WHERE) for column REM.
void	where_REM_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_REM(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column REM.
void	where_REM(java.lang.String filter) Define a filter (AND-ed WHERE) for column REM.
void	where_UID_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_UID_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UID.
void	where_UID_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UID.
void	where_UID_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column UID.
void	where_UID_isNull() Define a is-null filter (AND-ed WHERE) for column UID.
void	where_UID_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_UID(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column UID.
void	where_UID(java.lang.String filter) Define a filter (AND-ed WHERE) for column UID.
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.
void	where_WWW_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_WWW_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW.
void	where_WWW_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW.
void	where_WWW_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column WWW.
void	where_WWW_isNull() Define a is-null filter (AND-ed WHERE) for column WWW.
void	where_WWW_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_WWW(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column WWW.
void	where_WWW(java.lang.String filter) Define a filter (AND-ed WHERE) for column WWW.
void	where_ZIPCODE_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ZIPCODE_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE.
void	where_ZIPCODE_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE.
void	where_ZIPCODE_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column ZIPCODE.
void	where_ZIPCODE_isNull() Define a is-null filter (AND-ed WHERE) for column ZIPCODE.
void	where_ZIPCODE_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_ZIPCODE(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column ZIPCODE.
void	where_ZIPCODE(java.lang.String filter) Define a filter (AND-ed WHERE) for column ZIPCODE.

Methods inherited from class e4s.db.E4DBFilterOr

_getSVNVersionString, AND, getWhere, isEmpty, isNotEmpty, isNotNull, isNull, 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, toString

Methods inherited from class e4s.db.E4DBFilter

Escape, Escape, finalize, 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.E4DBFilter_Intf

getWhere, isWhereDefined, resetWhere

Constructor Detail

T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or

public T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or()

Method Detail

where_ADDRESS01

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

Define a filter (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS01

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

Define a filter (AND-ed WHERE with operator) for column ADDRESS01. STRING(60) Address Line #1

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_ADDRESS01_isNull

public void where_ADDRESS01_isNull()
                            throws E4DBException

Define a is-null filter (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:

E4DBException

where_ADDRESS01_isNotNull

public void where_ADDRESS01_isNotNull()
                               throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:

E4DBException

where_ADDRESS01_in

public void where_ADDRESS01_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS01. STRING(60) Address Line #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS01_notin

public void where_ADDRESS01_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS01. STRING(60) Address Line #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS01_isEmpty

public void where_ADDRESS01_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:

E4DBException

where_ADDRESS01_isNotEmpty

public void where_ADDRESS01_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS01. STRING(60) Address Line #1

Throws:

E4DBException

where_ADDRESS02

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

Define a filter (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS02

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

Define a filter (AND-ed WHERE with operator) for column ADDRESS02. STRING(60) Address Line #2

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_ADDRESS02_isNull

public void where_ADDRESS02_isNull()
                            throws E4DBException

Define a is-null filter (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:

E4DBException

where_ADDRESS02_isNotNull

public void where_ADDRESS02_isNotNull()
                               throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:

E4DBException

where_ADDRESS02_in

public void where_ADDRESS02_in(E4DBSelectDistinct filter)
                        throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS02. STRING(60) Address Line #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS02_notin

public void where_ADDRESS02_notin(E4DBSelectDistinct filter)
                           throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ADDRESS02. STRING(60) Address Line #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ADDRESS02_isEmpty

public void where_ADDRESS02_isEmpty()
                             throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:

E4DBException

where_ADDRESS02_isNotEmpty

public void where_ADDRESS02_isNotEmpty()
                                throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ADDRESS02. STRING(60) Address Line #2

Throws:

E4DBException

where_BELONGS_TO

public void where_BELONGS_TO(E4CompanyId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column BELONGS_TO. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_BELONGS_TO

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

Define a filter (AND-ed WHERE with operator) for column BELONGS_TO. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyId

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. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

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. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Company belongs to another company (can be null or empty)

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_CITY

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

Define a filter (AND-ed WHERE) for column CITY. STRING(60) City

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CITY

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

Define a filter (AND-ed WHERE with operator) for column CITY. STRING(60) City

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_CITY_isNull

public void where_CITY_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column CITY. STRING(60) City

Throws:

E4DBException

where_CITY_isNotNull

public void where_CITY_isNotNull()
                          throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column CITY. STRING(60) City

Throws:

E4DBException

where_CITY_in

public void where_CITY_in(E4DBSelectDistinct filter)
                   throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CITY. STRING(60) City

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CITY_notin

public void where_CITY_notin(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) CITY. STRING(60) City

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_CITY_isEmpty

public void where_CITY_isEmpty()
                        throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY. STRING(60) City

Throws:

E4DBException

where_CITY_isNotEmpty

public void where_CITY_isNotEmpty()
                           throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column CITY. STRING(60) City

Throws:

E4DBException

where_COMPANY_ID

public void where_COMPANY_ID(E4CompanyId filter)
                      throws E4DBException

Define a filter (AND-ed WHERE) for column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID

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

Define a filter (AND-ed WHERE with operator) for column COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID_in

public void where_COMPANY_ID_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_COMPANY_ID_notin

public void where_COMPANY_ID_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) COMPANY_ID. E4CompanyId defined as e4s.util.E4Long Numeric, incremental ID for companies Primary key, company - ID Autoincremental value

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_COUNTRYCODE

public void where_COUNTRYCODE(CountryCode filter)
                       throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRYCODE

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_COUNTRYCODE_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRYCODE_isNull

public void where_COUNTRYCODE_isNull()
                              throws E4DBException

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

Throws:

E4DBException

where_COUNTRYCODE_isNotNull

public void where_COUNTRYCODE_isNotNull()
                                 throws E4DBException

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

Throws:

E4DBException

where_COUNTRYCODE_in

public void where_COUNTRYCODE_in(E4DBSelectDistinct filter)
                          throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRYCODE_notin

public void where_COUNTRYCODE_notin(E4DBSelectDistinct filter)
                             throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_COUNTRYCODE_isEmpty

public void where_COUNTRYCODE_isEmpty()
                               throws E4DBException

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

Throws:

E4DBException

where_COUNTRYCODE_isNotEmpty

public void where_COUNTRYCODE_isNotEmpty()
                                  throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column COUNTRYCODE. 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 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_EMAIL

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

Define a filter (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_EMAIL

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

Define a filter (AND-ed WHERE with operator) for column EMAIL. STRING(60) Corporate eMail

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_EMAIL_isNull

public void where_EMAIL_isNull()
                        throws E4DBException

Define a is-null filter (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:

E4DBException

where_EMAIL_isNotNull

public void where_EMAIL_isNotNull()
                           throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:

E4DBException

where_EMAIL_in

public void where_EMAIL_in(E4DBSelectDistinct filter)
                    throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL. STRING(60) Corporate eMail

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_EMAIL_notin

public void where_EMAIL_notin(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) EMAIL. STRING(60) Corporate eMail

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_EMAIL_isEmpty

public void where_EMAIL_isEmpty()
                         throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:

E4DBException

where_EMAIL_isNotEmpty

public void where_EMAIL_isNotEmpty()
                            throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column EMAIL. STRING(60) Corporate eMail

Throws:

E4DBException

where_GIS_LATITUDE

public void where_GIS_LATITUDE(float filter)
                        throws E4DBException

Define a filter (AND-ed WHERE) for column GIS_LATITUDE. FLOAT GIS Latitude

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_GIS_LATITUDE

public void where_GIS_LATITUDE(int operator,
                               float filter)
                        throws E4DBException

Define a filter (AND-ed WHERE with operator) for column GIS_LATITUDE. FLOAT GIS Latitude

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_GIS_LONGITUDE

public void where_GIS_LONGITUDE(float filter)
                         throws E4DBException

Define a filter (AND-ed WHERE) for column GIS_LONGITUDE. FLOAT GIS Longitude

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_GIS_LONGITUDE

public void where_GIS_LONGITUDE(int operator,
                                float filter)
                         throws E4DBException

Define a filter (AND-ed WHERE with operator) for column GIS_LONGITUDE. FLOAT GIS Longitude

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_GROUP_ID

public void where_GROUP_ID(E4CompanyGroup filter)
                    throws E4DBException

Define a filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyGroup

where_GROUP_ID

public void where_GROUP_ID(int operator,
                           E4CompanyGroup filter)
                    throws E4DBException

Define a filter (AND-ed WHERE with operator) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyGroup

where_GROUP_ID_like

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

Define a filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyGroup

where_GROUP_ID_isNull

public void where_GROUP_ID_isNull()
                           throws E4DBException

Define a is-null filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:

E4DBException

See Also:

E4CompanyGroup

where_GROUP_ID_isNotNull

public void where_GROUP_ID_isNotNull()
                              throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:

E4DBException

See Also:

E4CompanyGroup

where_GROUP_ID_in

public void where_GROUP_ID_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyGroup

where_GROUP_ID_notin

public void where_GROUP_ID_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyGroup

where_GROUP_ID_isEmpty

public void where_GROUP_ID_isEmpty()
                            throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:

E4DBException

See Also:

E4CompanyGroup

where_GROUP_ID_isNotEmpty

public void where_GROUP_ID_isNotEmpty()
                               throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column GROUP_ID. E4CompanyGroup defined as e4s.util.E4String(16) Company Group Belongs to Group

Throws:

E4DBException

See Also:

E4CompanyGroup

where_LOGIN_NAME

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

Define a filter (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LOGIN_NAME

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

Define a filter (AND-ed WHERE with operator) for column LOGIN_NAME. STRING(16) Name for login

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_LOGIN_NAME_isNull

public void where_LOGIN_NAME_isNull()
                             throws E4DBException

Define a is-null filter (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:

E4DBException

where_LOGIN_NAME_isNotNull

public void where_LOGIN_NAME_isNotNull()
                                throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:

E4DBException

where_LOGIN_NAME_in

public void where_LOGIN_NAME_in(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_NAME. STRING(16) Name for login

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LOGIN_NAME_notin

public void where_LOGIN_NAME_notin(E4DBSelectDistinct filter)
                            throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) LOGIN_NAME. STRING(16) Name for login

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_LOGIN_NAME_isEmpty

public void where_LOGIN_NAME_isEmpty()
                              throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:

E4DBException

where_LOGIN_NAME_isNotEmpty

public void where_LOGIN_NAME_isNotEmpty()
                                 throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column LOGIN_NAME. STRING(16) Name for login

Throws:

E4DBException

where_NAME

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

Define a filter (AND-ed WHERE) for column NAME. STRING(60) Company Name

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(60) Company Name

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_NAME_isNull

public void where_NAME_isNull()
                       throws E4DBException

Define a is-null filter (AND-ed WHERE) for column NAME. STRING(60) Company Name

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(60) Company Name

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(60) Company Name

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(60) Company Name

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(60) Company Name

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(60) Company Name

Throws:

E4DBException

where_PHONE01

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

Define a filter (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_PHONE01

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

Define a filter (AND-ed WHERE with operator) for column PHONE01. STRING(60) Phone #1

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_PHONE01_isNull

public void where_PHONE01_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:

E4DBException

where_PHONE01_isNotNull

public void where_PHONE01_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:

E4DBException

where_PHONE01_in

public void where_PHONE01_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE01. STRING(60) Phone #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_PHONE01_notin

public void where_PHONE01_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE01. STRING(60) Phone #1

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_PHONE01_isEmpty

public void where_PHONE01_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:

E4DBException

where_PHONE01_isNotEmpty

public void where_PHONE01_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE01. STRING(60) Phone #1

Throws:

E4DBException

where_PHONE02

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

Define a filter (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_PHONE02

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

Define a filter (AND-ed WHERE with operator) for column PHONE02. STRING(60) Phone #2

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_PHONE02_isNull

public void where_PHONE02_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:

E4DBException

where_PHONE02_isNotNull

public void where_PHONE02_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:

E4DBException

where_PHONE02_in

public void where_PHONE02_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE02. STRING(60) Phone #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_PHONE02_notin

public void where_PHONE02_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) PHONE02. STRING(60) Phone #2

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_PHONE02_isEmpty

public void where_PHONE02_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:

E4DBException

where_PHONE02_isNotEmpty

public void where_PHONE02_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column PHONE02. STRING(60) Phone #2

Throws:

E4DBException

where_REM

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

Define a filter (AND-ed WHERE) for column REM. STRING(255) Remark

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_REM

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_REM_isNull

public void where_REM_isNull()
                      throws E4DBException

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

Throws:

E4DBException

where_REM_isNotNull

public void where_REM_isNotNull()
                         throws E4DBException

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

Throws:

E4DBException

where_REM_in

public void where_REM_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM. STRING(255) Remark

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_REM_notin

public void where_REM_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) REM. STRING(255) Remark

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_REM_isEmpty

public void where_REM_isEmpty()
                       throws E4DBException

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

Throws:

E4DBException

where_REM_isNotEmpty

public void where_REM_isNotEmpty()
                          throws E4DBException

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

Throws:

E4DBException

where_UID

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

Define a filter (AND-ed WHERE) for column UID. STRING(14) VAT Number

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_UID

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

Define a filter (AND-ed WHERE with operator) for column UID. STRING(14) VAT Number

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_UID_isNull

public void where_UID_isNull()
                      throws E4DBException

Define a is-null filter (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:

E4DBException

where_UID_isNotNull

public void where_UID_isNotNull()
                         throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:

E4DBException

where_UID_in

public void where_UID_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UID. STRING(14) VAT Number

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_UID_notin

public void where_UID_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) UID. STRING(14) VAT Number

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_UID_isEmpty

public void where_UID_isEmpty()
                       throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UID. STRING(14) VAT Number

Throws:

E4DBException

where_UID_isNotEmpty

public void where_UID_isNotEmpty()
                          throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UID. STRING(14) VAT Number

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 Valid until

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 Valid until

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 Valid until

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 Valid until

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 Valid until

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 Valid until

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 Valid until

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 Valid until

Throws:

E4DBException

where_WWW

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

Define a filter (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_WWW

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

Define a filter (AND-ed WHERE with operator) for column WWW. STRING(60) WWW Address

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_WWW_isNull

public void where_WWW_isNull()
                      throws E4DBException

Define a is-null filter (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:

E4DBException

where_WWW_isNotNull

public void where_WWW_isNotNull()
                         throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:

E4DBException

where_WWW_in

public void where_WWW_in(E4DBSelectDistinct filter)
                  throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) WWW. STRING(60) WWW Address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_WWW_notin

public void where_WWW_notin(E4DBSelectDistinct filter)
                     throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) WWW. STRING(60) WWW Address

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_WWW_isEmpty

public void where_WWW_isEmpty()
                       throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:

E4DBException

where_WWW_isNotEmpty

public void where_WWW_isNotEmpty()
                          throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column WWW. STRING(60) WWW Address

Throws:

E4DBException

where_ZIPCODE

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

Define a filter (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ZIPCODE

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

Define a filter (AND-ed WHERE with operator) for column ZIPCODE. STRING(10) ZIP Code

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_ZIPCODE_isNull

public void where_ZIPCODE_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:

E4DBException

where_ZIPCODE_isNotNull

public void where_ZIPCODE_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:

E4DBException

where_ZIPCODE_in

public void where_ZIPCODE_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ZIPCODE. STRING(10) ZIP Code

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ZIPCODE_notin

public void where_ZIPCODE_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) ZIPCODE. STRING(10) ZIP Code

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_ZIPCODE_isEmpty

public void where_ZIPCODE_isEmpty()
                           throws E4DBException

Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:

E4DBException

where_ZIPCODE_isNotEmpty

public void where_ZIPCODE_isNotEmpty()
                              throws E4DBException

Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column ZIPCODE. STRING(10) ZIP Code

Throws:

E4DBException

and

public T_E4S_COMPANY_Sel.T_E4S_COMPANY_And and()