CloneSet428


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
5410.981method_declaration
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
17411
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/datasetviewer/cellcomponent/DataTypeBinary.java
27438
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/datasetviewer/cellcomponent/DataTypeDouble.java
37440
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/datasetviewer/cellcomponent/DataTypeFloat.java
45367
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/datasetviewer/cellcomponent/DataTypeUnknown.java
Next
Last
Clone Instance
1
Line Count
7
Source Line
411
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/datasetviewer/cellcomponent/DataTypeBinary.java

/**
 * 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 || value.toString() == null || value.toString().length() == 0)
    return _colDef.getLabel() + " IS NULL";
  else
    //?? There does not seem to be any standard way to represent
    //?? binary data in a WHERE clause...
    return null; // tell caller we cannot use this in Where clause
}


Next
Previous
Clone Instance
2
Line Count
7
Source Line
438
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/datasetviewer/cellcomponent/DataTypeDouble.java

/**
 * 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 || value.toString() == null || value.toString().length() == 0)
    return _colDef.getLabel() + " IS NULL";
  else
    // since we cannot do exact matches on floating point
    // numbers, we cannot use this field in the WHERE clause.
    return null;
//                      return _colDef.getLabel() + "=" + value.toString();
}


Next
Previous
Clone Instance
3
Line Count
7
Source Line
440
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/datasetviewer/cellcomponent/DataTypeFloat.java

/**
 * 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 || value.toString() == null || value.toString().length() == 0)
    return _colDef.getLabel() + " IS NULL";
  else
    // since we cannot do exact matches on floating point
    // numbers, we cannot use this field in the WHERE clause.
    return "";
//                      return _colDef.getLabel() + "=" + value.toString();
}


First
Previous
Clone Instance
4
Line Count
5
Source Line
367
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/datasetviewer/cellcomponent/DataTypeUnknown.java

/**
 * 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 || value.toString() == null || value.toString().length() == 0)
    return _colDef.getLabel() + " IS NULL";
  else
    return "";
}


Clone AbstractionParameter Count: 1Parameter Bindings

/**
         * 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 || value.toString() == null || value.toString().length() == 0)
    return _colDef.getLabel() + " IS NULL";
  else
    // since we cannot do exact matches on floating point
    // numbers, we cannot use this field in the WHERE clause.
    //?? There does not seem to be any standard way to represent
    //?? binary data in a WHERE clause...
    return [[#variable1ce2e000]]; // tell caller we cannot use this in Where clause
//                      return _colDef.getLabel() + "=" + value.toString();
}
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#1ce2e000]]
null 
12[[#1ce2e000]]
null 
13[[#1ce2e000]]
"" 
14[[#1ce2e000]]
""