An Access query selects lines from an ascii file generated on a server.
The results are read from the host_monitor by a query in HM generating a table equal to the ascii file. In a specific linenumber there is a result of a calculation. Comparing this result in ODBC SQL test for alert when field in line X > 10 only works when the result is > 10. So far so good. When the result >10 and the alert limit <10 then there is no alert.
Is there any solution?
B.t.w. I posted this question already in the topic installation and configuration but now I hope my question is more clear.
Comparing textstring
Yes, now its more clear. At least I know you work with "ODBC query" test (not with Text Log test). Please don't mix problems in one topic 
As I think that field (that you compare to 10) is not numeric field. In this case HostMonitor compare it as string, so '15' is less than '2', 'a'<'b', '111'<'99', so on.
If you need to compare this field as number, change type of the field.
Regards
Alex
As I think that field (that you compare to 10) is not numeric field. In this case HostMonitor compare it as string, so '15' is less than '2', 'a'<'b', '111'<'99', so on.
If you need to compare this field as number, change type of the field.
Regards
Alex