| 5/10/2006 5:26:58 PM |
When I use isNull in an opath query it generates bad sql. Is there a fix for this? It puts a ")" in the wrong place.
adam
queryText.Append(" isNull (RateInstanceRateInstanceObject.ExpirationDate) ") |
| 5/11/2006 4:54:45 AM |
Hi Adam,
Relationship traversals are probably not being handled correctly when placed within the IsNull function. Traversals are generally not allowed in any function so this usage probably falls more in the "not currently supported" category than it does the "bug" category.
To fix the problem, move the traversal outside the ISNULL test, like so:
RateInstanceRateInstanceObject[IsNull(ExpirationDate)]
- Jeff Lanning |