hi am new to SQLite can anybody please tell me how this query can be solved in SQLite?
IF EXISTS (SELECT prod_batch_code FROM stock_tab WHERE prod_batch_code=1000) UPDATE stock_tab SET stock_qty=stock_qty+(SELECT purchase_qty ROM purchase_tab WHERE oduct_batch_code=1000 ) WHERE prod_batch_code=1000 ELSE INSERT INTO stock_tab(stock_id, prod_batch_code, stock_qty, stock_date) values (20009, 1003, 200, DATETIME('NOW') ); -- View this message in context: http://www.nabble.com/how-can-we-solve-IF-EXIST-in-SQLite-tp23828274p23828274.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users