BetweenPredicate

Represents a predicates for the BETWEEN SQL operator.

Namespace:
Inetdev.Data.Query
Type:
Class
Public:
Yes
Protected:
No
Sealed:
No
Abstract:
No
Inherits from:
Inetdev.Data.Query.Predicate

Constructors

BetweenPredicate

Default constructor

Signature:
public Void BetweenPredicate()

BetweenPredicate

Initializes a new instance of BetweenPredicate.

Signature:
public Void BetweenPredicate(col, value1, value2)
Parameters
Name Type Summary
col PredicateColumn The column object.
value1 Object The first value for the predicate.
value2 Object The second value for the predicate.

BetweenPredicate

Initializes a new instance of BetweenPredicate.

Signature:
public Void BetweenPredicate(col, value1, value2, negate)
Parameters
Name Type Summary
col PredicateColumn The column object.
value1 Object The first value for the predicate.
value2 Object The second value for the predicate.
negate Boolean Indicates whether the condition must be negated.

BetweenPredicate

Initializes a new instance of BetweenPredicate.

Signature:
public Void BetweenPredicate(col, value1, value2, negate, useParenthesis)
Parameters
Name Type Summary
col PredicateColumn The column object.
value1 Object The first value for the predicate.
value2 Object The second value for the predicate.
negate Boolean Indicates whether the condition must be negated.
useParenthesis Boolean Indicates whether the clause must be enclosed in parenthesis.

BetweenPredicate

Initializes a new instance of BetweenPredicate.

Signature:
public Void BetweenPredicate(rel, col, value1, value2)
Parameters
Name Type Summary
rel RelationalOperator The relation between predicates.
col PredicateColumn The column object.
value1 Object The first value for the predicate.
value2 Object The second value for the predicate.

BetweenPredicate

Initializes a new instance of BetweenPredicate.

Signature:
public Void BetweenPredicate(rel, col, value1, value2, negate)
Parameters
Name Type Summary
rel RelationalOperator The relation between predicates.
col PredicateColumn The column object.
value1 Object The first value for the predicate.
value2 Object The second value for the predicate.
negate Boolean Indicates whether the condition must be negated.

BetweenPredicate

Initializes a new instance of BetweenPredicate.

Signature:
public Void BetweenPredicate(rel, col, value1, value2, negate, useParenthesis)
Parameters
Name Type Summary
rel RelationalOperator The relation between predicates.
col PredicateColumn The column object.
value1 Object The first value for the predicate.
value2 Object The second value for the predicate.
negate Boolean Indicates whether the condition must be negated.
useParenthesis Boolean Indicates whether the clause must be enclosed in parenthesis.

Properties

Column

Column on which the predicate acts on.

Signature:
public PredicateColumn Column { get; set; }

Negate

Indicates whether the condition must be negated.

Signature:
public Boolean Negate { get; set; }

Value1

First value for the predicate.

Signature:
public Object Value1 { get; set; }

Value2

Second value for the predicate.

Signature:
public Object Value2 { get; set; }