Guest User

Untitled

a guest
Dec 16th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. UPDATE wms_purchaseorderproductdetails SET accepted_quantity,remarks = CASE product_id WHEN 623 THEN (1, 'APA') WHEN 627 THEN (1, 'Prakash') WHEN 614 THEN (1, 'Ambasta') WHEN 95 THEN (1, 'Amit') END WHERE product_id IN (623, 627, 614, 95) AND purchase_order_id=86;
  2. ERROR: syntax error at or near ","
  3. LINE 1: ..._purchaseorderproductdetails SET accepted_quantity,remarks =...
Add Comment
Please, Sign In to add comment