Well my DBA's are hard at it and have me stumped again. I'm using the ODBC Com addon to check a table and count the number of errors in it. This works great when the table actually has at least one error because the count is greater than 0. Since SQL doesn't return any rows for when the count = 0, ODBC com gives an error saying that it can't check for a down if there is no data to check. This makes perfect sense from the ODBC com's point of view, but I'm not sure how to work around the behavior of SQL.
It seems like I either need a way to tell ODBC Com addon that an empty recordset is automatically UP, OR a way to force SQL to return a row displaying "0" so that ODBC Com can check agianst it. Any ideas? Michael Shook Technical Analyst Saddle Creek Corporation 723 Joe Tamplin Industrial Blvd Macon GA 31217 478 742 8740 ext. 105 (work) 478 256 9318 (mobile) 478 742 7917 (fax) [EMAIL PROTECTED] http://www.saddlecrk.com --- [This E-mail scanned for viruses by Declude Virus] To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive
