SourcePro® 2024.1 |
SourcePro® API Reference Guide |
Used to build outer join constructs. More...
#include <rw/db/expr.h>
Public Member Functions | |
RWDBJoinExpr () | |
RWDBJoinExpr (const RWDBJoinExpr &jexpr) | |
RWDBJoinExpr & | on (const RWDBColumn &column) |
RWDBJoinExpr & | on (const RWDBCriterion &criterion) |
RWDBJoinExpr & | operator= (const RWDBJoinExpr &jexpr) |
![]() | |
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 |
Additional Inherited Members | |
![]() | |
enum | AsStringControlFlag { normal , suppressTagsOnColumns , noPlaceHolder , placeHolderNotRecommended } |
RWDBJoinExpr is created by a set of global functions that generate ANSI SQL outer join syntax. It represents a specialized type of RWDBExpr that is used only for building outer join constructs.
In this example, an RWDBJoinExpr is created anonymously by the related global function rwdbOuter(), and set as part of the FROM
clause.
RWDBJoinExpr::RWDBJoinExpr | ( | ) |
The default constructor is provided for convenience. Typically, RWDBJoinExpr instances are obtained through outer join global functions.
RWDBJoinExpr::RWDBJoinExpr | ( | const RWDBJoinExpr & | jexpr | ) |
Copy constructor. The created RWDBJoinExpr shares an implementation with jexpr.
RWDBJoinExpr & RWDBJoinExpr::on | ( | const RWDBColumn & | column | ) |
Adds the column to self's SQL USING
clause, which specifies the join columns for the join. Returns a reference to self.
RWDBJoinExpr & RWDBJoinExpr::on | ( | const RWDBCriterion & | criterion | ) |
Specifies the join condition as self's SQL ON
clause. If self already has an ON
clause, this method replaces it. Returns a reference to self.
RWDBJoinExpr & RWDBJoinExpr::operator= | ( | const RWDBJoinExpr & | jexpr | ) |
Assignment operator. Self shares an implementation with jexpr. Returns a reference to self.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the CROSS JOIN
SQL phrase between two tables.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the INNER JOIN
SQL phrase between two inner join expressions. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the INNER JOIN
SQL phrase between an inner join expression and a table. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the INNER JOIN
SQL phrase between two tables.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the INNER JOIN
SQL phrase between a table and an inner join expression. For databases that support precedence in inner joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the LEFT OUTER JOIN
SQL phrase between two outer join expressions. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the LEFT OUTER JOIN
SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the LEFT OUTER JOIN
SQL phrase between two tables.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the LEFT OUTER JOIN
SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr such that jexpr is evaluated first before the table is joined.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL LEFT OUTER JOIN
SQL phrase between two outer join expressions. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL LEFT OUTER JOIN
SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL LEFT OUTER JOIN
SQL phrase between two tables.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL LEFT OUTER JOIN
SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL FULL OUTER JOIN
SQL phrase between two outer join expressions. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL FULL OUTER JOIN
SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL FULL OUTER JOIN
SQL phrase between two tables.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL FULL OUTER JOIN
SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL RIGHT OUTER JOIN
SQL phrase between two outer join expressions. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL RIGHT OUTER JOIN
SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL RIGHT OUTER JOIN
SQL phrase between two tables.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the NATURAL RIGHT OUTER JOIN
SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN
SQL phrase between two outer join expressions. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN
SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN
SQL phrase between two tables.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the FULL OUTER JOIN
SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the RIGHT OUTER JOIN
SQL phrase between two outer join expressions. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the RIGHT OUTER JOIN
SQL phrase between an outer join expression and a table. This does not add any precedence to the constructs.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the RIGHT OUTER JOIN
SQL phrase between two tables.
|
related |
Returns an RWDBJoinExpr that represents an encapsulation of the RIGHT OUTER JOIN
SQL phrase between a table and an outer join expression. For databases that support precedence in outer joins, the generated SQL adds precedence to jexpr, such that jexpr is evaluated first before the table is joined.
Copyright © 2024 Rogue Wave Software, Inc., a Perforce company. All Rights Reserved. |