| XWhereOperationEnum Enumeration |
Enum OperationEnum
Namespace: Biolomics.SharedClasses
Assembly: Biolomics.SharedClasses (in Biolomics.SharedClasses.dll) Version: 1.0.0.0 (1.0.0.0)
SyntaxMembers| Member name | Value | Description | |
|---|---|---|---|
| Empty | 0 | Return an empty data set, using "Id = 0.5" or "1 = 0.5" | |
| All | 1 | >Return the whole data set, in fact without any where clause | |
| Sql | 2 | Apply the WHERE clause stored in m_Value blindly. Valid for MySql database only | |
| Eq | 11 | Equal | |
| Ne | 12 | ||
| StartWith | 131 | String Start with | |
| Contains | 132 | String contains | |
| EndWith | 133 | String ends with | |
| IsNull | 14 | IS NULL | |
| IsNotNull | 15 | IS NOT NULL | |
| In_ | 16 | IN() | |
| RegExp | 17 | REGEXP, value is always a string | |
| InRange | 18 | same as IN() but the Value contains an array with pairs of integers (first, last) | |
| Gt | 20 | Greater > | |
| Gte | 21 | Greater or Equal >= | |
| Lt | 22 | Less than | |
| Lte | 23 | Less than or Equal | |
| Mod_ | 24 | Modulo, to retrieve dates when only the year, or the month, or the day is given. | |
| And_ | 30 | And | |
| Or_ | 31 | OR | |
| Not_ | 32 | NOT | |
| AndIsNull | 41 | Test if (x AND y) = 0 | |
| AndIsNotNull | 42 |
See Also