Putting a NOT into the search-string of Selection-Action

[#1]

Hi all (Hi NMiller),

referring to thread #142908 I tried it for myself with

='<> 40191'

in the search string. But it wasn't as expected:

I will use next time "Select Exclude" but anyway: what is wrong here?

Regards, Roland

[#2]

Hi again,

sorry, I forgot the picture with the result:

[#3]

It will work if you include the field name. Try typing

=DateID<>40191

[#4]

Hi Tim,

this expression is the search-string of a button's selection-action. I want to select all except '40192' by pushing the button.

RR

[Miguel_Angel_Baeyens · Accepted solution]

Hello Roland,

Did you tried ?

='>40192<40192'

As far as I remember this should do what you want.

Hope that helps.

[#6]

Hellp Miguel,

many thanks for your answer.

I know this workaround. But I am not happy with it. As I read in the QV-help there are several relational operators. One of them is "<>" and is declared as "not equivalent". For me its hard to complain that "<" and ">" is working fine in a search mask, but not "<>".

And even more interresting is the handling (and especialy the comparing) of strings or dates. In the section relational operators of the QV-Help you find always "A numeric comparison is made ...". So what about text and date? As i mentioned before, there exist workarounds and really interesting threads in the forum, but for me it is not straight forward.

Regards Roland

[cheburashka]

Hello,

Is it possible that this is not working anymore?

I want to use the select field action in a button to select all the values of the field Classificatie except the value 'geen'.

I already tried following possibilities:

= '>geen<geen'
= '*' <> 'geen'
= '*' NOT 'geen'
= '*' ! 'geen'

Any suggestions?

_Koen