Content


NTL
Core
db::NotBetween

db::NotBetween


These are utility functions which help to build condition object to be used with queries and query builders representing NOT BETWEEN condition.

The result condition type for each function is specified as a comment below. Due to possible ambiguities (for example, db::NotBetween(L"name", L"Jack", L"John") seems fine but both String and DbValue have constructors accepting const wchar_t* argument and for compiler it is not obvious that the first argument should be interpreted as string and the second and third ones as values so that final condition would be column NOT BETWEEN value1 AND value2) you have to exactly specify the type of argument. As an alternative you can use db::nb*() functions instead.

DbCondition NotBetween(const String &operand1, const String &operand2, const String &operand3); // column1 NOT BETWEEN column2 AND column3
DbCondition NotBetween(const String &operand1, const String &operand2, const DbValue &operand3); // column1 NOT BETWEEN column2 AND value3
DbCondition NotBetween(const String &operand1, const String &operand2, DbCondition operand3); // column1 NOT BETWEEN column2 AND expression3
DbCondition NotBetween(const String &operand1, const DbValue &operand2, const String &operand3); // column1 NOT BETWEEN value2 AND column3
DbCondition NotBetween(const String &operand1, const DbValue &operand2, const DbValue &operand3); // column1 NOT BETWEEN value2 AND value3
DbCondition NotBetween(const String &operand1, const DbValue &operand2, DbCondition operand3); // column1 NOT BETWEEN value2 AND expression3
DbCondition NotBetween(const String &operand1, DbCondition operand2, const String &operand3); // column1 NOT BETWEEN expression2 AND column3
DbCondition NotBetween(const String &operand1, DbCondition operand2, const DbValue &operand3); // column1 NOT BETWEEN expression2 AND value3
DbCondition NotBetween(const String &operand1, DbCondition operand2, DbCondition operand3); // column1 NOT BETWEEN expression2 AND expression3
DbCondition NotBetween(const DbValue &operand1, const String &operand2, const String &operand3); // value1 NOT BETWEEN column2 AND column3
DbCondition NotBetween(const DbValue &operand1, const String &operand2, const DbValue &operand3); // value1 NOT BETWEEN column2 AND value3
DbCondition NotBetween(const DbValue &operand1, const String &operand2, DbCondition operand3); // value1 NOT BETWEEN column2 AND expression3
DbCondition NotBetween(const DbValue &operand1, const DbValue &operand2, const String &operand3); // value1 NOT BETWEEN value2 AND column3
DbCondition NotBetween(const DbValue &operand1, const DbValue &operand2, const DbValue &operand3); // value1 NOT BETWEEN value2 AND value3
DbCondition NotBetween(const DbValue &operand1, const DbValue &operand2, DbCondition operand3); // value1 NOT BETWEEN value2 AND expression3
DbCondition NotBetween(const DbValue &operand1, DbCondition operand2, const String &operand3); // value1 NOT BETWEEN expression2 AND column3
DbCondition NotBetween(const DbValue &operand1, DbCondition operand2, const DbValue &operand3); // value1 NOT BETWEEN expression2 AND value3
DbCondition NotBetween(const DbValue &operand1, DbCondition operand2, DbCondition operand3); // value1 NOT BETWEEN expression2 AND expression3
DbCondition NotBetween(DbCondition operand1, const String &operand2, const String &operand3); // expression1 NOT BETWEEN column2 AND column3
DbCondition NotBetween(DbCondition operand1, const String &operand2, const DbValue &operand3); // expression1 NOT BETWEEN column2 AND value3
DbCondition NotBetween(DbCondition operand1, const String &operand2, DbCondition operand3); // expression1 NOT BETWEEN column2 AND expression3
DbCondition NotBetween(DbCondition operand1, const DbValue &operand2, const String &operand3); // expression1 NOT BETWEEN value2 AND column3
DbCondition NotBetween(DbCondition operand1, const DbValue &operand2, const DbValue &operand3); // expression1 NOT BETWEEN value2 AND value3
DbCondition NotBetween(DbCondition operand1, const DbValue &operand2, DbCondition operand3); // expression1 NOT BETWEEN value2 AND expression3
DbCondition NotBetween(DbCondition operand1, DbCondition operand2, const String &operand3); // expression1 NOT BETWEEN expression2 AND column3
DbCondition NotBetween(DbCondition operand1, DbCondition operand2, const DbValue &operand3); // expression1 NOT BETWEEN expression2 AND value3
DbCondition NotBetween(DbCondition operand1, DbCondition operand2, DbCondition operand3); // expression1 NOT BETWEEN expression2 AND expression3
Namespace: nitisa::db
Include: Nitisa/Db/DbCondition.h