拼装SQL.例子
select ‘update adempiere.m_product p set p.length=‘ || p.length ||
‘ , p.width=‘ || p.width || ‘ , p.height=‘ || p.height || ‘,
p.weight =‘ || p.weight || ‘ where p.length = 0 and p.width = 0 and p.height = 0 and p.weight= 0 and p.sku = ‘‘‘ ||
p.sku || ‘‘‘ and p.isnew=‘‘Y‘‘;‘,
p.*
from adempiere.m_product p
where p.length <> 0
and p.width <> 0
and p.height <> 0
and p.weight <> 0
and p.isnew = ‘N‘;
得到的例子:
update adempiere.m_product p set p.length=5 , p.width=9 , p.height=3,
p.weight =.035 where p.length = 0 and p.width = 0 and p.height = 0 and p.weight= 0 and p.sku = ‘M010000000000000252‘ and p.isnew=‘Y‘;
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
