[Mono-list] (generic)DataTable SELECT logic
stifu at free.fr
Wed Feb 10 06:36:01 EST 2010
It looks like a Mono bug (or incompatibility), could you file a bug report
By the way, could you try using another expression, such as "IS NULL" or "IS
That's what Microsoft recommends, too:
"You can check for null values using the "is null" and "is not null"
jan van der watt wrote:
> Please let me know if this should be posted to another forum.
> Has anyone else seen that the DataTable.Select(filterExpression) produces
> funny when evaluating an expression that involves NULL, or is it just my
> data/code gone wrong?
> My code snippet is this:
> DataTable lookup_value_schema_table = <an appropriate table>;
> The dataset has either NULL or True in that column (but not False).
> On MS .NET, only the rows with "True" are returned, but on Mono, ALL rows
> are returned. It seems that the expression "NULL<>0" is FALSE on MS .NET,
> but TRUE on Mono.
> If I use:
> the results are as expected (i.e. only the rows with "True" in the column
> are returned)
> Mono-list maillist - Mono-list at lists.ximian.com
View this message in context: http://old.nabble.com/%28generic%29DataTable-SELECT-logic-tp27528859p27529788.html
Sent from the Mono - General mailing list archive at Nabble.com.
More information about the Mono-list