How can we search NULL values in a foundset?

Classic Servoy
1

How can we search NULL values in a foundset?

According to my scenario, I want to do a search for getting records which are having NULL values for the box_id.(box_id’s data type is a bigint)

So I tried as follows.

if(foundset.find())
{
foundset.box_id = null;
foundset.search();
}

if(foundset.find())
{
foundset.box_id = ‘=null’;
foundset.search();
}

if(foundset.find())
{
foundset.box_id = ‘IS null’;
foundset.search();
}

But still it doesn’t work. Does anyone have an idea?

Regards,
Nisala Perera

2

Have you checked the documentation for this? I think the search operators are well documented.

Paul

3

Hi,

Try this:

if(foundset.find())
{
foundset.box_id = ‘^’
foundset.search();
}

4

Thank you.

Regards,
Nisala Perera