ODBC Query with no result produces unknown state

roman · Post by **roman** » Sat Dec 14, 2002 4:38 am

I have an ODBC Query test, which I expect to bring no result. In this case, the state goes to unknown.
ok, I could begin with SELECT COUNT (*) FROM ..., but in the case there is a result, I can't see the value but only the count in the reply column.
Is there a possibility to add new conditions "is NULL" and "is NOT NULL"?

KS-Soft · Post by **KS-Soft** » Mon Dec 16, 2002 4:48 pm

May be better add new option:
- Set Ok/Bad/Unknown status when specified field unavailable
What do you think?

Regards
Alex

roman · Post by **roman** » Wed Dec 18, 2002 8:41 am

Accepted. Thanks