JoinConstraintType Enumeration |
The type of constraint check.
Namespace: PDTec.IceNet.Core.Database.Query
Assembly: PDTec.IceNet.Core (in PDTec.IceNet.Core.dll) Version: 7.2.0.0 (7.2.7583.15464)
SyntaxC#
public enum JoinConstraintType
Members| Member name | Value | Description | |
|---|---|---|---|
| Symbol | 0 | No check, the Name of the constraint is available as symbol for SQL expressions. | |
| Equal | 1 | Check for equality. | |
| NotEqual | 2 | Check for value difference. | |
| Like | 3 | Check for string pattern (can include '*' and '?' wildcards). | |
| Between | 4 | Check if the value is beween first and second parameter. | |
| Less | 5 | Check if the value is less than the first parameter. | |
| LessEqual | 6 | Check if the value is less or equal than the first parameter. | |
| Greater | 7 | Check if the value is greater than the first parameter. | |
| GreaterEqual | 8 | Check if the value is greater or equal than the first parameter. | |
| In | 9 | Check if the value is in the result set provided by the subquery. | |
| NotIn | 10 | Check if the value is not in the result set provided by the subquery. | |
| InSet | 11 | Check if the value is in a set provided as the first parameter. | |
| TypeOf | 12 | Checks if the value (object type ID) is equal or subtype of the first parameter (object type ID). |
See Also