/**
* When updating the database, generate a string form of this object value
* that can be used in the WHERE clause to match the value in the database. A
* return value of null means that this column cannot be used in the WHERE
* clause, while a return of "null" (or "is null", etc) means that the column
* can be used in the WHERE clause and the value is actually a null value.
* This function must also include the column label so that its output is of
* the form: "columnName = value" or "columnName is null" or whatever is
* appropriate for this column in the database.
*/
/**
* When updating the database, generate a string form of this object value
* that can be used in the WHERE clause to match the value in the database.
* A return value of null means that this column cannot be used in the WHERE
* clause, while a return of "null" (or "is null", etc) means that the column
* can be used in the WHERE clause and the value is actually a null value.
* This function must also include the column label so that its output
* is of the form:
* "columnName = value"
* or
* "columnName is null"
* or whatever is appropriate for this column in the database.
*/
public String getWhereClauseValue(Object value, ISQLDatabaseMetaData md) {
if (value == null || (( [[#variable1cc6e8e0]]) value).getData() == null)
return _colDef.getLabel() + " IS NULL";
else
return ""; // CLOB cannot be used in WHERE clause // BLOB cannot be used in WHERE clause
}
|