Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
3571 Tampilan

I want copy property filed list_price value to product_template list_price2

res_id  is product.template,id

insert into product_template (id, list_price2)
       select cast(substring(res_id from 18) as int) as id, value_float
              from ir_property where name='list_price';
ERROR:  null value in column "uom_id" violates not-null constraint
DETAIL:  Failing row contains (32645, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1).

 

Avatar
Buang
Penulis Jawaban Terbai

I solved it.

UPDATE product_template p2
SET list_price2 = p1.value_float
FROM ir_property p1
WHERE p2.id  = cast(substring(p1.res_id from 18) as int) and p1.name='list_price' 
AND p2.list_price2 IS DISTINCT FROM p1.value_float;

Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
1
Nov 22
5566
1
Okt 21
3244
2
Nov 18
10161
4
Mar 15
5206
1
Mar 15
6005