SQL queries as test?

MADS · Post by **MADS** » Tue Jan 31, 2006 3:11 am

Hi,

Is there a way to do a count * from "table" to return the number of rows as ReplyNum?

Marc

Yoorix · Post by **Yoorix** » Tue Jan 31, 2006 7:31 am

Yes, sure.

Select count(*) from TableName

Standard ANSI syntax.

And then check "Alert when field in " row 1 col1 "< then" Value.

Regards,
Yoorix

KS-Soft · Post by **KS-Soft** » Tue Jan 31, 2006 9:57 am

Is there a way to do a count * from "table" to return the number of rows as ReplyNum?

Why you have posted this question into "Problems and Bugs" forum?

ODBC Quesry test method shows some error? If you see some error, please provide information about that error: HostMonitor version, Windows version, Service Pack, ODBC driver, what exactly error do you see?

Regards
Alex