jimm.datavision.source.ncsql
Class NCQuery

java.lang.Object
  extended by jimm.datavision.source.Query
      extended by jimm.datavision.source.sql.SQLQuery
          extended by jimm.datavision.source.ncsql.NCQuery
All Implemented Interfaces:
Writeable

public class NCQuery
extends SQLQuery

Queries build NC query strings. They contain tables, joins, and where clauses.

Author:
Jim Menard, jimm@io.com

Field Summary
 
Fields inherited from class jimm.datavision.source.sql.SQLQuery
preparedStmtValues, tables
 
Fields inherited from class jimm.datavision.source.Query
joins, report, selectables, SORT_ASCENDING, SORT_DESCENDING, SORT_UNDEFINED, sortOrders, sortSelectables, whereClause
 
Constructor Summary
NCQuery(Report report)
          Constructor.
 
Method Summary
 java.lang.String quoted(java.lang.String name)
          Quotes those parts of a table or column name that need to be quoted.
 
Methods inherited from class jimm.datavision.source.sql.SQLQuery
addParameter, addParameterForDisplay, addTable, buildFrom, buildJoins, buildOrderBy, buildSelect, buildUserWhereClause, buildWhereClause, findSelectablesUsed, getNumTables, getTablesUsed, getWhereClauseForDisplay, getWhereClauseForPreparedStatement, prepare, queryAsString, setParameters, toPreparedStatementString, toString
 
Methods inherited from class jimm.datavision.source.Query
addAllJoins, addJoin, addSort, clearJoins, clearSorts, containsReferenceTo, getEditableWhereClause, getNumSelectables, getWhereClause, indexOfSelectable, joins, reloadColumns, removeJoin, removeSort, selectables, setEditableWhereClause, setWhereClause, sortedSelectables, sortOrderOf, writeExtras, writeXML
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

NCQuery

public NCQuery(Report report)
Constructor.

Parameters:
report - the report for which this query will generate NC
Method Detail

quoted

public java.lang.String quoted(java.lang.String name)
Quotes those parts of a table or column name that need to be quoted.

Different databases and JDBC drivers treat case sensitively differently. We assume the database is case-sensitive.

Overrides:
quoted in class SQLQuery
Parameters:
name - a table or column name
Returns:
a quoted version of the name