Comparing textstring

nvdvelden · Joined: 10 Mar 2004 Posts: 6

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.

KS-Soft · Joined: 03 Apr 2002 Posts: 12801 Location: USA

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