Searching for excluded value in a numeric field like ^1

Classic Servoy
1

Hi,

I would like to search in a numeric or text field for all values not 1. By default the value is “NULL”.

As far as the documentation it would be ^1, but that does not give me the correct foundset.

Another mystery is that under OS X I can not write “^1” into the field in searchmode. It always disappears. When I copy - paste it into the field it works.

Any hints?

Thanks Oliver

Servoy 4.1.3 / Client: OS X J2SE 5.0 / Server: WinXP

2

Hi Oliver,

^ would be searching for NULL.
! is the operator for NOT.
So you should be using !1 as the search criteria for searching all records that are not 1.

Hope this helps.

3

Thanks, that was easy. I have to check the documentation once more.

Oliver