My this query is working perfectly...
OdbcDataAdapter daa = new OdbcDataAdapter(string.Format("SELECT SUM (IBHAND) Stock_in_WhereHouse FROM MM410LIB.INVBAL WHERE INUMBR= {0} AND ISTORE <> 14", strbrn), stof);
I want to use the IF command in this statment how its possible..
I need this but not working, 100% there is any query problem from my side, please fix it and inform me:
"IF ((SELECT COUNT(*) FROM MM410LIB.INVBAL WHERE INUMBR= {0} AND STORE = 14) < 5000)"
Go to the complete details ...