BetweenExpression

Overview

The BetweenExpression class implements BetweenExpression that checks belonging to a range of values.

This is one of the classes used to dynamically build WHERE statements from code (Dynamic Where feature of Data Abstract).

For example, a WHERE clause of this query

SELECT * FROM Customers WHERE CustomerId between 5000 AND 5010;

will be presented as:

WhereExpression lResult;
lResult = new BetweenExpression(
              new FieldExpression("CustomerId"),
              new ConstantExpression("5000", DataType.Integer),
              new ConstantExpression("5010", DataType.Integer));

Location

DataAbstract.js

• Ancestry: BetweenExpression

Instance Methods

---

Creates new instance of BetweenExpression class.

aNode1 BETWEEN aNode2 AND aNode3

function constructor BetweenExpression(aNode1, aNode2, aNode3)

Parameters:

• aNode1: Represents datapoint expression (for example, field name) in current between expression.
• aNode2: Represents lower value of the current between expression.
• aNode3: Represents upper value of the current between expression.

---

Returns a string with the XML representation of the expression

function toXML()

---