Show / Hide Table of Contents

Class NotBetween

The NOT BETWEEN class

Inheritance
Object
QueryElement
Restriction
Compare
ArrayCompare
NotBetween
Implements
ICloneable
Inherited Members
ArrayCompare._right
ArrayCompare.GetSubElements()
ArrayCompare.Right
Compare.IsTableInvolved(TableInfo)
Compare.AreAllTablesInvolved(TableInfo, SoTable[])
Compare.GetInvolvedTables(Dictionary<TableInfo, Object>)
Compare.GetTypedSubElement<T>()
Compare.Left
Compare.IsRelationDescription
Restriction.And(Restriction)
Restriction.Or(Restriction)
Restriction.RestrictionAnd(Restriction, Restriction)
Restriction.RestrictionOr(Restriction, Restriction)
Object.Equals(Object)
Object.Equals(Object, Object)
Object.ReferenceEquals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
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
ArrayCompare.Clone()
Remarks

This method is used by the 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
ArrayCompare.ToString()

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top