RWDBCriterion Class Reference

Represents the result of applying logical operators to RWDBExpr. It encapsulates search conditions that are used in SQL WHERE clauses and CHECK constraints. More...

#include <rw/db/expr.h>

Inheritance diagram for RWDBCriterion:

Public Member Functions
	RWDBCriterion (void)
Public Member Functions inherited from RWDBExpr
	RWDBExpr ()
	RWDBExpr (const RWDBExpr &expr)
	RWDBExpr (char value)
	RWDBExpr (unsigned char value)
	RWDBExpr (short value)
	RWDBExpr (unsigned short value)
	RWDBExpr (int value)
	RWDBExpr (unsigned int value)
	RWDBExpr (long int value)
	RWDBExpr (unsigned long int value)
	RWDBExpr (long long value)
	RWDBExpr (unsigned long long value)
	RWDBExpr (float value)
	RWDBExpr (double value)
	RWDBExpr (long double value)
	RWDBExpr (const char *value)
	RWDBExpr (const wchar_t *value)
	RWDBExpr (const RWCString &value)
	RWDBExpr (const RWDecimalPortable &value)
	RWDBExpr (const RWDateTime &value)
	RWDBExpr (const RWDBDateTime &value)
	RWDBExpr (const RWDBDuration &value)
	RWDBExpr (const RWDate &value)
	RWDBExpr (const RWTime &value)
	RWDBExpr (const RWDBBlob &value)
	RWDBExpr (const RWBasicUString &value)
	RWDBExpr (const RWDBMBString &value)
	RWDBExpr (const RWWString &value)
	RWDBExpr (const RWDBValue &value, bool usePhraseBook=true)
	RWDBExpr (const RWDBColumn &column)
	RWDBExpr (const RWDBSelectorBase &subSelect)
	RWDBExpr (RWDBValueManip manip)
	RWDBExpr (const RWCollection &collection)
	RWDBExpr (const RWDBTable &)
	RWDBExpr (const RWDBColumn &left, const RWDBExpr &right)
	RWDBExpr (const RWDBColumn &left, const RWDBValue &right)
RWCString	asString (const RWDBPhraseBook &phraseBook, AsStringControlFlag control=normal) const
RWDBCriterion	between (const RWDBExpr &expression1, const RWDBExpr &expression2) const
RWDBCriterion	in (const RWDBExpr &expression1) const
RWDBCriterion	isNull (void) const
bool	isValid (void) const
RWDBCriterion	leftOuterJoin (const RWDBExpr &expression) const
RWDBCriterion	like (const RWDBExpr &expression1) const
RWDBCriterion	matchUnique (const RWDBExpr &expression1) const
RWDBExpr &	operator= (const RWDBExpr &expr)
RWDBCriterion	rightOuterJoin (const RWDBExpr &expression) const

Additional Inherited Members
Public Types inherited from RWDBExpr
enum	AsStringControlFlag { normal, suppressTagsOnColumns, noPlaceHolder, placeHolderNotRecommended }
Related Functions inherited from RWDBExpr
RWDBCriterion	operator! (const RWDBCriterion &)
RWDBCriterion	operator!= (const RWDBExpr &, const RWDBExpr &)
RWDBExpr	operator% (const RWDBExpr &, const RWDBExpr &)
RWDBCriterion	operator&& (const RWDBCriterion &, const RWDBCriterion &)
RWDBExpr	operator* (const RWDBExpr &, const RWDBExpr &)
RWDBExpr	operator+ (const RWDBExpr &, const RWDBExpr &)
RWDBExpr	operator+ (const RWDBExpr &)
RWDBExpr	operator- (const RWDBExpr &, const RWDBExpr &)
RWDBExpr	operator- (const RWDBExpr &)
RWDBExpr	operator/ (const RWDBExpr &, const RWDBExpr &)
RWDBCriterion	operator< (const RWDBExpr &, const RWDBExpr &)
RWDBCriterion	operator<= (const RWDBExpr &, const RWDBExpr &)
RWDBCriterion	operator== (const RWDBExpr &, const RWDBExpr &)
RWDBCriterion	operator> (const RWDBExpr &, const RWDBExpr &)
RWDBCriterion	operator>= (const RWDBExpr &, const RWDBExpr &)
RWDBCriterion	operator|| (const RWDBCriterion &, const RWDBCriterion &)
RWDBExpr	rwdbAvg (const RWDBExpr &expr)
RWDBExpr	rwdbCast (const RWDBExpr &expr, const RWDBValue &type)
RWDBExpr	rwdbCast (const RWDBExpr &expr, const RWDBValue &typeName, const RWDBExpr &formatString)
RWDBExpr	rwdbCast (const RWDBExpr &expr, const RWDBValue &typeName, const RWDBExpr &formatString, const RWDBExpr &secondaryFormat)
RWDBExpr	rwdbCharLength (const RWDBExpr &expr)
RWDBExpr	rwdbCount (const RWDBExpr &expr)
RWDBExpr	rwdbCount ()
RWDBExpr	rwdbCountDistinct (const RWDBExpr &expr)
RWDBExpr	rwdbCurrentUser ()
RWDBCriterion	rwdbExists (const RWDBSelectorBase &select)
RWDBExpr	rwdbLower (const RWDBExpr &expr)
RWDBExpr	rwdbMax (const RWDBExpr &expr)
RWDBExpr	rwdbMin (const RWDBExpr &expr)
RWDBExpr	rwdbName (const RWCString &name, const RWDBExpr &expr)
RWDBExpr	rwdbPosition (const RWDBExpr &expr1, const RWDBExpr &expr2)
RWDBExpr	rwdbSessionUser ()
RWDBExpr	rwdbSubString (const RWDBExpr &expr1, const RWDBExpr &expr2)
RWDBExpr	rwdbSubString (const RWDBExpr &expr1, const RWDBExpr &expr2, const RWDBExpr &expr3)
RWDBExpr	rwdbSum (const RWDBExpr &expr)
RWDBExpr	rwdbSystemDateTime ()
RWDBExpr	rwdbSystemUser ()
RWDBExpr	rwdbTrimBoth (const RWDBExpr &expr1, const RWDBExpr &expr2)
RWDBExpr	rwdbTrimLeading (const RWDBExpr &expr1, const RWDBExpr &expr2)
RWDBExpr	rwdbTrimTrailing (const RWDBExpr &expr1, const RWDBExpr &expr2)
RWDBExpr	rwdbUpper (const RWDBExpr &expr)

Detailed Description

RWDBCriterion is the result of applying logical operators to RWDBExpr. It is used to encapsulate search conditions that are used in SQL WHERE clauses and SQL CHECK constraints.

RWDBCriterion represents a specialized type of RWDBExpr that is evaluated in an SQL statement as a boolean value. RWDBCriterion adds neither components nor member functions to the base class. Instead, it ensures that a nonboolean expression is not placed in a context that requires a boolean expression during compilation.

Synopsis

#include <rw/db/expr.h>

See also

RWDBCriterion is a special case of RWDBExpr. Please see RWDBExpr for details about RWDBCriterion usage, including operators and constructors.

Example

In this example, an RWDBCriterion is created anonymously to be used as part of an SQL WHERE clause:

int x = somevalue;
RWDBSelector select = myDbase.selector();
select.where(myTable["myColumn"] != x);

Constructor & Destructor Documentation

RWDBCriterion::RWDBCriterion

(

void

)

The default constructor creates an empty criterion.