Hi All,
I want to subtract the database value from the userinput and want to update table with a new value,
I have one selltable where seller can sell only the items which are in stock now i want to subtract that user input quantity from the stock quantity.i have made sql statement like this is it correct ,if not how can we do it,
and please forward me some dummy code which have implimented like this,
String sql=" update itemdetails set quantity =quantity-Double.parseDouble(stock_text.getText() WHERE itemcode=?";