|
View previous topic :: View next topic |
Author |
Message |
morphil
Joined: 17 Sep 2012 Posts: 5 Location: Österreich
|
Posted: Mon Nov 09, 2020 4:05 am Post subject: ODBC Query with right value, but false alert value |
|
|
As you can see in the screenshot, the test return value =6 and the alert value is > 100.
Nevertheless it always turns Status=Bad
Did I miss something? |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12818 Location: USA
|
Posted: Mon Nov 09, 2020 8:04 am Post subject: |
|
|
integer 6 < integer 100
string "6" > string "100"
Are you checking My SQL database?
My SQL manual tells about integer type but in reality it returns varchar.
If server returns some non-numeric data and you need to compare such data as numbers, you may use Optional status processing options (Test properties dialog).
E.g.
- set Normal status if "%SuggestedReply%"<=100
- set Warning status if "%SuggestedReply%">100
Regards
Alex |
|
Back to top |
|
|
morphil
Joined: 17 Sep 2012 Posts: 5 Location: Österreich
|
Posted: Mon Nov 09, 2020 9:00 am Post subject: |
|
|
perfect, this works, thanks |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|