e4s.db.systabledef
Class T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_And

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterAnd
              e4s.db.systabledef.T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_And

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterAnd_Intf

Enclosing class:

T_E4S_TRANS_SYS_Sel

public static class T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_And
extends E4DBFilterAnd
implements E4DBFilter_Intf

Filter to be used as AND 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_TRANS_SYS_Sel.T_E4S_TRANS_SYS_And()

Method Summary

T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_Or	or()
void	where_DATMOD_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATMOD_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_isNull() Define a is-null filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATMOD(java.util.Date filter) Define a filter (AND-ed WHERE) for column DATMOD.
void	where_DATMOD(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column DATMOD.
void	where_DATNEW_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATNEW_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_isNull() Define a is-null filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DATNEW(java.util.Date filter) Define a filter (AND-ed WHERE) for column DATNEW.
void	where_DATNEW(int operator, java.util.Date filter) Define a filter (AND-ed WHERE with operator) for column DATNEW.
void	where_DEST_LAN_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DEST_LAN_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_LAN.
void	where_DEST_LAN_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_LAN.
void	where_DEST_LAN_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DEST_LAN.
void	where_DEST_LAN_isNull() Define a is-null filter (AND-ed WHERE) for column DEST_LAN.
void	where_DEST_LAN_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column DEST_LAN.
void	where_DEST_LAN_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DEST_LAN(int operator, Language filter) Define a filter (AND-ed WHERE with operator) for column DEST_LAN.
void	where_DEST_LAN(Language filter) Define a filter (AND-ed WHERE) for column DEST_LAN.
void	where_DEST_TXT_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DEST_TXT_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_TXT.
void	where_DEST_TXT_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column DEST_TXT.
void	where_DEST_TXT_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column DEST_TXT.
void	where_DEST_TXT_isNull() Define a is-null filter (AND-ed WHERE) for column DEST_TXT.
void	where_DEST_TXT_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_DEST_TXT(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column DEST_TXT.
void	where_DEST_TXT(java.lang.String filter) Define a filter (AND-ed WHERE) for column DEST_TXT.
void	where_SRC_LAN_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_SRC_LAN_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_LAN.
void	where_SRC_LAN_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_LAN.
void	where_SRC_LAN_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column SRC_LAN.
void	where_SRC_LAN_isNull() Define a is-null filter (AND-ed WHERE) for column SRC_LAN.
void	where_SRC_LAN_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column SRC_LAN.
void	where_SRC_LAN_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_SRC_LAN(int operator, Language filter) Define a filter (AND-ed WHERE with operator) for column SRC_LAN.
void	where_SRC_LAN(Language filter) Define a filter (AND-ed WHERE) for column SRC_LAN.
void	where_SRC_TXT_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_SRC_TXT_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_TXT.
void	where_SRC_TXT_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column SRC_TXT.
void	where_SRC_TXT_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column SRC_TXT.
void	where_SRC_TXT_isNull() Define a is-null filter (AND-ed WHERE) for column SRC_TXT.
void	where_SRC_TXT_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_SRC_TXT(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column SRC_TXT.
void	where_SRC_TXT(java.lang.String filter) Define a filter (AND-ed WHERE) for column SRC_TXT.
void	where_UPD_COMPANY_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_UPD_COMPANY_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_UPD_COMPANY(E4CompanyId filter) Define a filter (AND-ed WHERE) for column UPD_COMPANY.
void	where_UPD_COMPANY(int operator, E4CompanyId filter) Define a filter (AND-ed WHERE with operator) for column UPD_COMPANY.
void	where_UPD_MODE_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_UPD_MODE_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_MODE.
void	where_UPD_MODE_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_MODE.
void	where_UPD_MODE_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column UPD_MODE.
void	where_UPD_MODE_isNull() Define a is-null filter (AND-ed WHERE) for column UPD_MODE.
void	where_UPD_MODE_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_UPD_MODE(int operator, java.lang.String filter) Define a filter (AND-ed WHERE with operator) for column UPD_MODE.
void	where_UPD_MODE(java.lang.String filter) Define a filter (AND-ed WHERE) for column UPD_MODE.
void	where_UPD_USER_in(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_UPD_USER_isEmpty() Define a is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_USER.
void	where_UPD_USER_isNotEmpty() Define a NOT is-empty filter (empty string or null) - (AND-ed WHERE) for column UPD_USER.
void	where_UPD_USER_isNotNull() Define a is-NOT-null filter (AND-ed WHERE) for column UPD_USER.
void	where_UPD_USER_isNull() Define a is-null filter (AND-ed WHERE) for column UPD_USER.
void	where_UPD_USER_like(java.lang.String filter) Define a filter (AND-ed WHERE) for column UPD_USER.
void	where_UPD_USER_notin(E4DBSelectDistinct filter) Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..)
void	where_UPD_USER(E4CompanyUserId filter) Define a filter (AND-ed WHERE) for column UPD_USER.
void	where_UPD_USER(int operator, E4CompanyUserId filter) Define a filter (AND-ed WHERE with operator) for column UPD_USER.

Methods inherited from class e4s.db.E4DBFilterAnd

_getSVNVersionString, 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, 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_TRANS_SYS_Sel.T_E4S_TRANS_SYS_And

public T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_And()

Method Detail

where_DATMOD

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DATMOD_isNull

public void where_DATMOD_isNull()
                         throws E4DBException

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

Throws:

E4DBException

where_DATMOD_isNotNull

public void where_DATMOD_isNotNull()
                            throws E4DBException

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

Throws:

E4DBException

where_DATMOD_in

public void where_DATMOD_in(E4DBSelectDistinct filter)
                     throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD_notin

public void where_DATMOD_notin(E4DBSelectDistinct filter)
                        throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATMOD_isEmpty

public void where_DATMOD_isEmpty()
                          throws E4DBException

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

Throws:

E4DBException

where_DATMOD_isNotEmpty

public void where_DATMOD_isNotEmpty()
                             throws E4DBException

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

Throws:

E4DBException

where_DATNEW

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DATNEW_isNull

public void where_DATNEW_isNull()
                         throws E4DBException

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

Throws:

E4DBException

where_DATNEW_isNotNull

public void where_DATNEW_isNotNull()
                            throws E4DBException

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

Throws:

E4DBException

where_DATNEW_in

public void where_DATNEW_in(E4DBSelectDistinct filter)
                     throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW_notin

public void where_DATNEW_notin(E4DBSelectDistinct filter)
                        throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DATNEW_isEmpty

public void where_DATNEW_isEmpty()
                          throws E4DBException

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

Throws:

E4DBException

where_DATNEW_isNotEmpty

public void where_DATNEW_isNotEmpty()
                             throws E4DBException

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

Throws:

E4DBException

where_DEST_LAN

public void where_DEST_LAN(Language filter)
                    throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DEST_LAN

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DEST_LAN_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DEST_LAN_isNull

public void where_DEST_LAN_isNull()
                           throws E4DBException

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

Throws:

E4DBException

where_DEST_LAN_isNotNull

public void where_DEST_LAN_isNotNull()
                              throws E4DBException

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

Throws:

E4DBException

where_DEST_LAN_in

public void where_DEST_LAN_in(E4DBSelectDistinct filter)
                       throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DEST_LAN_notin

public void where_DEST_LAN_notin(E4DBSelectDistinct filter)
                          throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DEST_LAN_isEmpty

public void where_DEST_LAN_isEmpty()
                            throws E4DBException

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

Throws:

E4DBException

where_DEST_LAN_isNotEmpty

public void where_DEST_LAN_isNotEmpty()
                               throws E4DBException

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

Throws:

E4DBException

where_DEST_TXT

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

Define a filter (AND-ed WHERE) for column DEST_TXT. STRING(255) Destination Text

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DEST_TXT

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_DEST_TXT_isNull

public void where_DEST_TXT_isNull()
                           throws E4DBException

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

Throws:

E4DBException

where_DEST_TXT_isNotNull

public void where_DEST_TXT_isNotNull()
                              throws E4DBException

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

Throws:

E4DBException

where_DEST_TXT_in

public void where_DEST_TXT_in(E4DBSelectDistinct filter)
                       throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DEST_TXT. STRING(255) Destination Text

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DEST_TXT_notin

public void where_DEST_TXT_notin(E4DBSelectDistinct filter)
                          throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) DEST_TXT. STRING(255) Destination Text

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_DEST_TXT_isEmpty

public void where_DEST_TXT_isEmpty()
                            throws E4DBException

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

Throws:

E4DBException

where_DEST_TXT_isNotEmpty

public void where_DEST_TXT_isNotEmpty()
                               throws E4DBException

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

Throws:

E4DBException

where_SRC_LAN

public void where_SRC_LAN(Language filter)
                   throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SRC_LAN

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_SRC_LAN_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SRC_LAN_isNull

public void where_SRC_LAN_isNull()
                          throws E4DBException

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

Throws:

E4DBException

where_SRC_LAN_isNotNull

public void where_SRC_LAN_isNotNull()
                             throws E4DBException

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

Throws:

E4DBException

where_SRC_LAN_in

public void where_SRC_LAN_in(E4DBSelectDistinct filter)
                      throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SRC_LAN_notin

public void where_SRC_LAN_notin(E4DBSelectDistinct filter)
                         throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SRC_LAN_isEmpty

public void where_SRC_LAN_isEmpty()
                           throws E4DBException

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

Throws:

E4DBException

where_SRC_LAN_isNotEmpty

public void where_SRC_LAN_isNotEmpty()
                              throws E4DBException

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

Throws:

E4DBException

where_SRC_TXT

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

Define a filter (AND-ed WHERE) for column SRC_TXT. STRING(255) Source Text

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SRC_TXT

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

Define a filter (AND-ed WHERE with operator) for column SRC_TXT. STRING(255) Source Text

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_SRC_TXT_isNull

public void where_SRC_TXT_isNull()
                          throws E4DBException

Define a is-null filter (AND-ed WHERE) for column SRC_TXT. STRING(255) Source Text

Throws:

E4DBException

where_SRC_TXT_isNotNull

public void where_SRC_TXT_isNotNull()
                             throws E4DBException

Define a is-NOT-null filter (AND-ed WHERE) for column SRC_TXT. STRING(255) Source Text

Throws:

E4DBException

where_SRC_TXT_in

public void where_SRC_TXT_in(E4DBSelectDistinct filter)
                      throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SRC_TXT. STRING(255) Source Text

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SRC_TXT_notin

public void where_SRC_TXT_notin(E4DBSelectDistinct filter)
                         throws E4DBException

Define a SELECT WHERE column IN (SELECT DISTINCT column FROM..) SRC_TXT. STRING(255) Source Text

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_SRC_TXT_isEmpty

public void where_SRC_TXT_isEmpty()
                           throws E4DBException

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

Throws:

E4DBException

where_SRC_TXT_isNotEmpty

public void where_SRC_TXT_isNotEmpty()
                              throws E4DBException

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

Throws:

E4DBException

where_UPD_COMPANY

public void where_UPD_COMPANY(E4CompanyId filter)
                       throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_UPD_COMPANY

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyId

where_UPD_COMPANY_in

public void where_UPD_COMPANY_in(E4DBSelectDistinct filter)
                          throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_UPD_COMPANY_notin

public void where_UPD_COMPANY_notin(E4DBSelectDistinct filter)
                             throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyId

where_UPD_MODE

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_UPD_MODE

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

where_UPD_MODE_isNull

public void where_UPD_MODE_isNull()
                           throws E4DBException

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

Throws:

E4DBException

where_UPD_MODE_isNotNull

public void where_UPD_MODE_isNotNull()
                              throws E4DBException

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

Throws:

E4DBException

where_UPD_MODE_in

public void where_UPD_MODE_in(E4DBSelectDistinct filter)
                       throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_UPD_MODE_notin

public void where_UPD_MODE_notin(E4DBSelectDistinct filter)
                          throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

where_UPD_MODE_isEmpty

public void where_UPD_MODE_isEmpty()
                            throws E4DBException

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

Throws:

E4DBException

where_UPD_MODE_isNotEmpty

public void where_UPD_MODE_isNotEmpty()
                               throws E4DBException

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

Throws:

E4DBException

where_UPD_USER

public void where_UPD_USER(E4CompanyUserId filter)
                    throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_UPD_USER

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

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

Parameters:

filter - the value to be compared within the SQL statement

operator - the comparsion operator E4DBFilter

Throws:

E4DBException

See Also:

E4CompanyUserId

where_UPD_USER_like

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

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_UPD_USER_isNull

public void where_UPD_USER_isNull()
                           throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_UPD_USER_isNotNull

public void where_UPD_USER_isNotNull()
                              throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_UPD_USER_in

public void where_UPD_USER_in(E4DBSelectDistinct filter)
                       throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_UPD_USER_notin

public void where_UPD_USER_notin(E4DBSelectDistinct filter)
                          throws E4DBException

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

Parameters:

filter - the value to be compared within the SQL statement

Throws:

E4DBException

See Also:

E4CompanyUserId

where_UPD_USER_isEmpty

public void where_UPD_USER_isEmpty()
                            throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

where_UPD_USER_isNotEmpty

public void where_UPD_USER_isNotEmpty()
                               throws E4DBException

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

Throws:

E4DBException

See Also:

E4CompanyUserId

or

public T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_Or or()