SourcePro® API Reference Guide

 
List of all members | Public Member Functions
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:
RWDBExpr

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
 
RWDBExproperator= (const RWDBExpr &expr)
 
RWDBCriterion rightOuterJoin (const RWDBExpr &expression) const
 

Additional Inherited Members

- Public Types inherited from RWDBExpr
enum  AsStringControlFlag { normal, suppressTagsOnColumns, noPlaceHolder, placeHolderNotRecommended }
 

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.

Copyright © 2023 Rogue Wave Software, Inc., a Perforce company. All Rights Reserved.