Hi,

I found out how to do this with columns containing values in a selected list (by introducing a value ” : ” in the list), but I still can't figure out how to do this for editable fields. I've tried to do a search on all elements that contains a caracter (#column,#contain,%), and then to display all elements that don't match with this pattern, but I get all rows…

Do you have any idea on how to perform this kind of search? Is it a bug in my implementation of the grid, or a grid problem?

Thanks

Hi,

Thanks for your reply.

Actually, I don't have any more this problem for varchar. This is how I fixed it for varchar columns:

– modify the database columns' default to '' instead of NULL (doesn't work on text type)

alter table

alter column set Default ''

– modify all values of all columns that contain a NULL value, and set it to the new default's one

update

set = '' where IS NULL

– insert a space in the filter's entry, and press enter to get the results.

Now, the filter is ok for selectable values (I added a ; :Nothing in the values list), for text and for varchar values. I still can't perform this kind of search on dates (all cells that don't contain dates).

ps1 :