SourcePro® API Reference Guide

 
Loading...
Searching...
No Matches
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 (char value)
 
 RWDBExpr (const char *value)
 
 RWDBExpr (const RWBasicUString &value)
 
 RWDBExpr (const RWCollection &collection)
 
 RWDBExpr (const RWCString &value)
 
 RWDBExpr (const RWDate &value)
 
 RWDBExpr (const RWDateTime &value)
 
 RWDBExpr (const RWDBBlob &value)
 
 RWDBExpr (const RWDBColumn &column)
 
 RWDBExpr (const RWDBColumn &left, const RWDBExpr &right)
 
 RWDBExpr (const RWDBColumn &left, const RWDBValue &right)
 
 RWDBExpr (const RWDBDateTime &value)
 
 RWDBExpr (const RWDBDuration &value)
 
 RWDBExpr (const RWDBExpr &expr)
 
 RWDBExpr (const RWDBMBString &value)
 
 RWDBExpr (const RWDBSelectorBase &subSelect)
 
 RWDBExpr (const RWDBTable &)
 
 RWDBExpr (const RWDBValue &value, bool usePhraseBook=true)
 
 RWDBExpr (const RWDecimalPortable &value)
 
 RWDBExpr (const RWTime &value)
 
 RWDBExpr (const RWWString &value)
 
 RWDBExpr (const wchar_t *value)
 
 RWDBExpr (double value)
 
 RWDBExpr (float value)
 
 RWDBExpr (int value)
 
 RWDBExpr (long double value)
 
 RWDBExpr (long int value)
 
 RWDBExpr (long long value)
 
 RWDBExpr (RWDBValueManip manip)
 
 RWDBExpr (short value)
 
 RWDBExpr (unsigned char value)
 
 RWDBExpr (unsigned int value)
 
 RWDBExpr (unsigned long int value)
 
 RWDBExpr (unsigned long long value)
 
 RWDBExpr (unsigned short value)
 
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);
Encapsulates the SQL SELECT statement.
Definition select.h:369

Constructor & Destructor Documentation

◆ RWDBCriterion()

RWDBCriterion::RWDBCriterion ( void )

The default constructor creates an empty criterion.

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