Hi,
what language is this? it certainly is not SQL or a "query".
I suspect that you can not use "insert or replace" (see
http://www.sqlite.org/lang_insert.html), because you look first for a
record with prod_batch_code=1000, and if you do not find it you insert
one with prod_batch_code = 1003.
S,. it seems to me that you have to implement the logic in your application.
Martin
robinsmathew wrote:
> 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') );
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
