Class NotBetween

The NOT BETWEEN class

Inheritance
object
QueryElement
Restriction
Compare
ArrayCompare
NotBetween
Implements
Inherited Members
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public class NotBetween : ArrayCompare, ICloneable

Constructors

NotBetween(Argument, Argument, Argument)

Default constructor Example sql query: find all associates where associate_id NOT between 5 and 10

SELECT TO.associate_id
FROM associate T0
WHERE associate_id NOT BETWEEN 5 AND 10;
Declaration
public NotBetween(Argument left, Argument min, Argument max)
Parameters
Type Name Description
Argument left

Argument
Argument min

Minimum value
Argument max

Maximum value

Methods

Clone()

Clone the query.

Declaration
public override object Clone()
Returns
Type Description
object

Copy of the node and its sub-elements
Overrides
Remarks

This method is used by the SentryQueryUpdater to modify a query with sentry extensions without affecting the original query.

ToString()

String output.

Declaration
public override string ToString()
Returns
Type Description
string

a NOT BETWEEN b AND c
Overrides

Implements

Extension Methods