using < > != operators in searches in a method

Classic Servoy
1

Hi,

I can perform a find using any of the following "< > != " etc, without problem manually, but only “=” works with the following code. What am I missing, do I need to pass it differently ???

//******************************************************
//first search clears records and loads default foundset
//******************************************************

	var vDefaultSearchColumn = arguments[0]
	var vDefaultSearch = arguments[1]
	var vOperator = arguments[12]
	
	if(vDefaultSearchColumn != "null")
		
		{
	
		
		switch (vOperator)
		{
			case "=": 
			forms[vFormName].controller.find() //enter find mode
			forms[vFormName][vDefaultSearchColumn] = vDefaultSearch //equals
			forms[vFormName].controller.search(true,false)//do clear and don't extend current foundset
			break
			case ">":
			forms[vFormName].controller.find() //enter find mode
			forms[vFormName][vDefaultSearchColumn] > vDefaultSearch //greater than
			forms[vFormName].controller.search(true,false)//do clear and don't extend current foundset
			break
			case "!=":
			forms[vFormName].controller.find() //enter find mode
			forms[vFormName][vDefaultSearchColumn] != vDefaultSearch //not equal
			forms[vFormName].controller.search(true,false)//do clear and don't extend current foundset
			break 
			case "<":
			forms[vFormName].controller.find() //enter find mode
			forms[vFormName][vDefaultSearchColumn] < vDefaultSearch //less than
			forms[vFormName].controller.search(true,false)//do clear and don't extend current foundset
			break
			default:
			forms[vFormName].controller.find() //enter find mode
			forms[vFormName][vDefaultSearchColumn] = vDefaultSearch //equals
			forms[vFormName].controller.search(true,false)//do clear and don't extend current foundset
		}		
	
		};
2

You really have to enter the operator in the field, for example:

forms[vFormName][vDefaultSearchColumn] = ">" + vDefaultSearch
3

Hi Joas,
Many thanks that fixed it,