Range search integer

Classic Servoy
1

Hi All,

I have an integer field “year” (2003, 2004, 2005,…)

When I do a manual find in this field “2003…2004” and press F3 everything goes fine.

But when I use methods with global fields, this does not work:

controller.find()
year = globals.year_start + “…” + globals.year_stop

Strange: in find mode “2003…2004” is displayed exactly the same.

Anyone?

TIA
Stef

2

Stef,

This should work:

controller.find()
year = globals.year_start + “…” + globals.year_stop;
controller.search()

Erich

3

No, it doesn’t!

Thanks anyway.

4

I solved it this way:

var query = “SELECT evaluation.evaluationid FROM evaluation WHERE evaluation.eva_year BETWEEN " + globals.eva_year_start + " AND " + globals.eva_year_stop + " order by 1 asc”