SourcePro® 2024.1 |
SourcePro® API Reference Guide |
Used to build searched CASE
expressions.
More...
#include <rw/db/expr.h>
Public Member Functions | |
RWDBSearchedCaseExpr () | |
RWDBSearchedCaseExpr (const RWDBSearchedCaseExpr &searchedCaseExpr) | |
void | else_ (const RWDBExpr &elseExpr) |
RWDBSearchedCaseExpr & | operator= (const RWDBSearchedCaseExpr &searchedCaseExpr) |
void | when (const RWDBCriterion &whenCrit, const RWDBExpr &thenExpr) |
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 |
RWDBExpr & | operator= (const RWDBExpr &expr) |
RWDBCriterion | rightOuterJoin (const RWDBExpr &expression) const |
RWDBSearchedCaseExpr represents a specialized type of RWDBExpr used to specify a searched SQL CASE
expression.
WHEN
expressions and an ELSE
expression, then is finally inserted into the SELECT
list. RWDBSearchedCaseExpr::RWDBSearchedCaseExpr | ( | ) |
The default constructor builds a RWDBSearchedCaseExpr.
RWDBSearchedCaseExpr::RWDBSearchedCaseExpr | ( | const RWDBSearchedCaseExpr & | searchedCaseExpr | ) |
Copy constructor. The created RWDBSearchedCaseExpr shares an implementation with searchedCaseExpr.
void RWDBSearchedCaseExpr::else_ | ( | const RWDBExpr & | elseExpr | ) |
Specifies the ELSE
expression for self as elseExpr. If self already has an ELSE
clause, this method replaces it.
RWDBSearchedCaseExpr & RWDBSearchedCaseExpr::operator= | ( | const RWDBSearchedCaseExpr & | searchedCaseExpr | ) |
Assignment operator. Self shares an implementation with searchedCaseExpr. Returns a reference to self.
void RWDBSearchedCaseExpr::when | ( | const RWDBCriterion & | whenCrit, |
const RWDBExpr & | thenExpr ) |
Appends a WHEN/THEN
clause to self where the argument whenCrit encapsulates the WHEN
condition, and the argument thenExpr encapsulates the THEN
return expression.
Copyright © 2024 Rogue Wave Software, Inc., a Perforce company. All Rights Reserved. |