[Mono-list] (generic)DataTable SELECT logic

Stifu 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
for it?

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:
> Hi,
> Please let me know if this should be posted to another forum.
> Has anyone else seen that the DataTable.Select(filterExpression) produces
> a
> 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>;
> lookup_value_schema_table.Select("IsDeletedColumn<>0")
> 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:
> lookup_value_schema_table.Select("IsDeletedColumn=True")
> the results are as expected (i.e. only the rows with "True" in the column
> are returned)
> Thanks
> Jan
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list

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 mailing list