e4s.db.freefield
Class E4DBModifyFreefields

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterAnd
              e4s.db.E4DBModifyCommon
                  e4s.db.freefield.E4DBModifyFreefields

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterAnd_Intf

Direct Known Subclasses:

T_E4S_COMPANY_GROUP_Mod, T_E4S_COMPANY_Mod, T_E4S_COMPANY_USER_Mod

public abstract class E4DBModifyFreefields
extends E4DBModifyCommon

Field Summary

Fields inherited from class e4s.db.E4DBModifyCommon

AUTOINCREMENT_MODE_DATABASE_AUTO, AUTOINCREMENT_MODE_DATABASE_SELECT, AUTOINCREMENT_MODE_ON_CLIENT, AUTOINCREMENT_MODE_ON_TABLE, m_assign, m_AutoincrMode, m_AutoincrValues

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

E4DBModifyFreefields(E4DBConnection_Intf con, E4DBTableName tableName)

E4DBModifyFreefields(E4DBConnection_Intf con, E4DBTableName tableName, E4ApplObj_Intf applobj)

E4DBModifyFreefields(E4DBModify modify, boolean copy_where)

E4DBModifyFreefields(E4DBSelect select, boolean copy_where, E4ApplObj_Intf applobj)

E4DBModifyFreefields(E4DBTableName tableName)

E4DBModifyFreefields(E4DBTableName tableName, E4ApplObj_Intf applobj)

Method Summary

static java.lang.String	_getSVNVersionString() Get version info string from subversion.
void	executeDelete_IgnoreFreefields()
void	executeInsert_IgnoreFreefields()
void	executeUpdate_IgnoreFreefields()
void	finalize()
protected java.lang.String	get_final_FieldValue_OnInsert(E4DBColumnName cName)
T_E4S_FREEFIELD_DEF_Obj[]	getFreevalDefinitions() Get the definitions of the free fields.
static T_E4S_FREEFIELD_DEF_Obj[]	getFreevalDefinitions(E4ApplObj_Intf applobj, E4DBTableName tablename) Get the definitions of the free fields.
T_E4S_FREEFIELD_DEF_Obj[]	getFreevalDefinitions(E4DBConnection_Intf con) Get the definitions of the free fields.
static T_E4S_FREEFIELD_DEF_Obj[]	getFreevalDefinitions(E4DBConnection_Intf con, E4ApplObj_Intf applobj, E4DBTableName tablename) Get the definitions of the free fields.
E4Fieldset	getFreevalInputfields() Create a E4Fieldset object that includes all the input fields for the freefield definitions.
static E4Fieldset	getFreevalInputfields(E4ApplObj_Intf applobj, E4DBTableName tablename) Create a E4Fieldset object that includes all the input fields for the freefield definitions.
protected void	insertFreevalues(E4DBTableName tablename, java.lang.String idx1)
protected void	insertFreevalues(E4DBTableName tablename, java.lang.String idx1, java.lang.String idx2)
protected void	insertFreevalues(E4DBTableName tablename, java.lang.String idx1, java.lang.String idx2, java.lang.String idx3)
void	reset()
void	setFreeval(E4DBFreeFieldName fieldname, boolean val) Set a "freefield value".
void	setFreeval(E4DBFreeFieldName fieldname, char val)
void	setFreeval(E4DBFreeFieldName fieldname, java.util.Date val) Set a "freefield value".
void	setFreeval(E4DBFreeFieldName fieldname, E4Date val) Set a "freefield value".
void	setFreeval(E4DBFreeFieldName fieldname, E4Long val) Set a "freefield value".
void	setFreeval(E4DBFreeFieldName fieldname, E4String val) Set a "freefield value".
void	setFreeval(E4DBFreeFieldName fieldname, float val) Set a "freefield value".
void	setFreeval(E4DBFreeFieldName fieldname, int val) Set a "freefield value".
void	setFreeval(E4DBFreeFieldName fieldname, long val) Set a "freefield value".
void	setFreeval(E4DBFreeFieldName fieldname, java.lang.String val)
void	setFreeval(E4DBFreeValue fv) Set a "freefield value".
void	setFreeval(E4DBFreeValue[] fv) Set a "freefield value".
void	setFreeval(E4DBFreeValueContent[] freevalues)
protected void	updateFreevalues(E4DBTableName tablename, java.lang.String idx1)
protected void	updateFreevalues(E4DBTableName tablename, java.lang.String idx1, java.lang.String idx2)
protected void	updateFreevalues(E4DBTableName tablename, java.lang.String idx1, java.lang.String idx2, java.lang.String idx3)

Methods inherited from class e4s.db.E4DBModifyCommon

close, disableLogging, enableLogging, executeDelete, executeInsert, executeSQL, executeSQL, executeSQL, executeSQL, executeUpdate, get_AutoincrMode, getConnection, getNextAutoincr, getReferenceDelete, getReferenceLookup, getTableName, isLogging, isSet, isSetAny, isUnicodeEnabled, removeNullValues, resetNextAutoincr, set_AutoincrMode, set, set, set, set, set, set, set, set, set, set, set, set, set, set, set, setNull, toString

Methods inherited from class e4s.db.E4DBFilterAnd

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

Methods inherited from class e4s.db.E4DBFilter

Escape, Escape, getApplObj, getClient, getSession, getWhere, isWhereDefined, OP, resetWhere, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter, setFilter, setWhere, toString

Methods inherited from class e4s.util.E4Object

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

Methods inherited from class java.lang.Object

clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface e4s.db.E4DBFilter_Intf

isWhereDefined, resetWhere

Constructor Detail

E4DBModifyFreefields

public E4DBModifyFreefields(E4DBModify modify,
                            boolean copy_where)
                     throws E4DBException

Throws:

E4DBException

E4DBModifyFreefields

public E4DBModifyFreefields(E4DBSelect select,
                            boolean copy_where,
                            E4ApplObj_Intf applobj)
                     throws E4DBException

Throws:

E4DBException

E4DBModifyFreefields

public E4DBModifyFreefields(E4DBConnection_Intf con,
                            E4DBTableName tableName,
                            E4ApplObj_Intf applobj)

E4DBModifyFreefields

public E4DBModifyFreefields(E4DBConnection_Intf con,
                            E4DBTableName tableName)

E4DBModifyFreefields

public E4DBModifyFreefields(E4DBTableName tableName)
                     throws E4DBException

Throws:

E4DBException

E4DBModifyFreefields

public E4DBModifyFreefields(E4DBTableName tableName,
                            E4ApplObj_Intf applobj)
                     throws E4DBException

Throws:

E4DBException

Method Detail

setFreeval

public void setFreeval(E4DBFreeValueContent[] freevalues)

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       char val)

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       java.lang.String val)

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       boolean val)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fieldname - the name of the field

val - the value for the field

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       long val)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fieldname - the name of the field

val - the value for the field

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       int val)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fieldname - the name of the field

val - the value for the field

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       float val)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fieldname - the name of the field

val - the value for the field

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       java.util.Date val)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fieldname - the name of the field

val - the value for the field

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       E4Date val)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fieldname - the name of the field

val - the value for the field

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       E4String val)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fieldname - the name of the field

val - the value for the field

setFreeval

public void setFreeval(E4DBFreeFieldName fieldname,
                       E4Long val)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fieldname - the name of the field

val - the value for the field

setFreeval

public void setFreeval(E4DBFreeValue fv)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fv - the value including the name

See Also:

E4DBFreeValueContent.getName(), E4DBFreeValueContent.getValue(), setFreeval(e4s.db.freefield.E4DBFreeValue[])

setFreeval

public void setFreeval(E4DBFreeValue[] fv)

Set a "freefield value". This means, that the value is not stored in the core table, instead it will be stored in T_E4S_FREEFIELD_VAL_Sel with a reference to the core table using the first unique index definition (made by the data dictionary).

Parameters:

fv - one or more values including the name. Does not perform any delete if values are null.

See Also:

E4DBFreeValueContent.getName(), E4DBFreeValueContent.getValue(), setFreeval(e4s.db.freefield.E4DBFreeValue)

reset

public void reset()

Overrides:

reset in class E4DBModifyCommon

get_final_FieldValue_OnInsert

protected java.lang.String get_final_FieldValue_OnInsert(E4DBColumnName cName)

insertFreevalues

protected void insertFreevalues(E4DBTableName tablename,
                                java.lang.String idx1)
                         throws E4DBException

Throws:

E4DBException

insertFreevalues

protected void insertFreevalues(E4DBTableName tablename,
                                java.lang.String idx1,
                                java.lang.String idx2)
                         throws E4DBException

Throws:

E4DBException

insertFreevalues

protected void insertFreevalues(E4DBTableName tablename,
                                java.lang.String idx1,
                                java.lang.String idx2,
                                java.lang.String idx3)
                         throws E4DBException

Throws:

E4DBException

updateFreevalues

protected void updateFreevalues(E4DBTableName tablename,
                                java.lang.String idx1)
                         throws E4DBException

Throws:

E4DBException

updateFreevalues

protected void updateFreevalues(E4DBTableName tablename,
                                java.lang.String idx1,
                                java.lang.String idx2)
                         throws E4DBException

Throws:

E4DBException

updateFreevalues

protected void updateFreevalues(E4DBTableName tablename,
                                java.lang.String idx1,
                                java.lang.String idx2,
                                java.lang.String idx3)
                         throws E4DBException

Throws:

E4DBException

getFreevalDefinitions

public T_E4S_FREEFIELD_DEF_Obj[] getFreevalDefinitions()
                                                throws E4DBException

Get the definitions of the free fields.

Returns:

the definitions

Throws:

E4DBException

getFreevalDefinitions

public T_E4S_FREEFIELD_DEF_Obj[] getFreevalDefinitions(E4DBConnection_Intf con)
                                                throws E4DBException

Get the definitions of the free fields.

Returns:

the definitions

Throws:

E4DBException

executeInsert_IgnoreFreefields

public void executeInsert_IgnoreFreefields()
                                    throws E4DBException

Throws:

E4DBException

executeUpdate_IgnoreFreefields

public void executeUpdate_IgnoreFreefields()
                                    throws E4DBException

Throws:

E4DBException

executeDelete_IgnoreFreefields

public void executeDelete_IgnoreFreefields()
                                    throws E4DBException

Throws:

E4DBException

getFreevalInputfields

public E4Fieldset getFreevalInputfields()
                                 throws E4DBException

Create a E4Fieldset object that includes all the input fields for the freefield definitions.

Returns:

the new created E4Fieldset

Throws:

E4DBException

See Also:

getFreevalDefinitions(e4s.application.E4ApplObj_Intf,e4s.db.E4DBTableName), getFreevalInputfields(e4s.application.E4ApplObj_Intf,e4s.db.E4DBTableName)

getFreevalInputfields

public static E4Fieldset getFreevalInputfields(E4ApplObj_Intf applobj,
                                               E4DBTableName tablename)
                                        throws E4DBException

Create a E4Fieldset object that includes all the input fields for the freefield definitions.

Parameters:

applobj - the application object

tablename - the table the freefields are associated with

Returns:

the new created E4Fieldset

Throws:

E4DBException

See Also:

E4DBSelectFreefields.getFreevalDefinitions(e4s.application.E4ApplObj_Intf,e4s.db.E4DBTableName)

getFreevalDefinitions

public static T_E4S_FREEFIELD_DEF_Obj[] getFreevalDefinitions(E4ApplObj_Intf applobj,
                                                              E4DBTableName tablename)
                                                       throws E4DBException

Get the definitions of the free fields.

Parameters:

applobj - the application object

tablename - the requested table

Returns:

the definitions

Throws:

E4DBException

See Also:

getFreevalDefinitions(), E4DBSelectFreefields.getFreevalDefinitions(e4s.application.E4ApplObj_Intf,e4s.db.E4DBTableName)

getFreevalDefinitions

public static T_E4S_FREEFIELD_DEF_Obj[] getFreevalDefinitions(E4DBConnection_Intf con,
                                                              E4ApplObj_Intf applobj,
                                                              E4DBTableName tablename)
                                                       throws E4DBException

Get the definitions of the free fields.

Parameters:

applobj - the application object

tablename - the requested table

Returns:

the definitions

Throws:

E4DBException

See Also:

getFreevalDefinitions(), E4DBSelectFreefields.getFreevalDefinitions(e4s.application.E4ApplObj_Intf,e4s.db.E4DBTableName)

finalize

public void finalize()

Overrides:

finalize in class E4DBModifyCommon

_getSVNVersionString

public static java.lang.String _getSVNVersionString()

Get version info string from subversion.

Returns:

the version info string.

See Also:

E4Util.getRevisionCodeFromSVN(Class)