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 NOT NULL"? That's what Microsoft recommends, too: http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression%28VS.85%29.aspx "You can check for null values using the "is null" and "is not null" expressions." 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 - [email protected] > 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. _______________________________________________ Mono-list maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-list
