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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
