Searching on integer column

Classic Servoy
1

Hi everyone,

I’m having a problem with searching on an integer column of check type on a form using a method - when I search 1 or “1” in the column and then ask for the omitted records, no records are returned. I know about half of the records have this column empty. However, when I sort on this column, the column is correctly ordered.

Any help appreciated,

Thanks in advance,

Ben

Servoy 3.5.3 on WinXPMCE

2

why don’t you search like this if (!columnname)…

That will check for the conditions 0 and null

3

What you are suggesting would work well in a loop, Marcel, but I was thinking more of a method search to get to the empty integer records:

forms[frmName].controller.find();
forms[frmName].i_printed_already = "null";
forms[frmName].controller.search();

var c = databaseManager.getFoundSetCount(foundset);  // this always returns zero...

Any other ideas?

Ben

4

uhmm, if I am not mistaken you should make null a ^.
But that is by heart…

5

You’re a genius Marcel - ‘forms[frmName].i_printed_already = “^”;’ did it! :D

Now, if I could just get in the habit of reading the documentation before bothering everyone here… :roll:

Thanks immensely,

Ben

6

Now, if I could just get in the habit of reading the documentation before bothering everyone here…

Well, I can create a driver for your…
Simply donate 100 Euro to me per helpful answer.
That will teach you :)

7

Puti it on my tab for now please… :wink:

Related question: Is there a reason why, after doing the search on the form using ‘^’, the menu item ‘Show omitted records’ returns nothing? Same result when using a method… :?

Ben

8

hmm, not that I can think of no…