Ed Leafe schrieb: > On Jan 25, 2009, at 8:58 AM, Sibylle Koczian wrote: > >> I'm trying out the DataSet.filter() method, and I don't find a way to >> filter for records with NULL / NOT NULL or '' / 'any non empty string' >> in a given column. The wiki doesn't mention this, and it doesn't >> mention >> any operator for "not equal". > > I've added support for not equal, using '!=' or 'ne'. I've also fixed > the problem with None values not being correctly passed to the SQLite > execute statement. Let me know if these are working for you now. >
I'm not quite sure how this is meant to work. Filtering for columns with values equal or unequal to the empty string works now. Using ds.filter(fieldname, None) to filter for NULL in column fieldname doesn't work, and as nothing in the code translates this to "IS NULL", I don't wonder. I don't get error messages, but an empty result set. But filtering for NULL values works correctly with the filterByExpression() method - which isn't mentioned in the Wiki. I probably should look into the code much more. Thank you, Sibylle _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
