Not Equal foundset problem

Classic Servoy
1

Hello,

I have a table with 1000 records, if I search in the field companyName for “CompanyX” My foundset will count just 1 record.
If I try to find all records except “CompanyX” my foundset counts only 440 records instead of 999.

controller.find()
	company = '!CompanyX'
	controller.search(true,false)
	
	var foundCount = databaseManager.getFoundSetCount(foundset)
	var count = databaseManager.getTableCount(foundset);
	application.output(foundCount + '  '+count)

I tried also with the getDataSetByQuery-method, but the result is the same.

2

My guess is there are a lot of ‘null’ value records in your table.
Can you query for that number of records?

3

Bingo!

Thank you Marc