Error: The action can not be performed because ...could not be locked?

longwansheng發表於2015-06-25
ErrorORM

 

在訂單產生DELIVERY ID時經常出現
Error: The action can not be performed because the selected records could not be locked? 

經查是個別CHAR欄位後面帶了空格.用下面方式處理即可.

update wsh_delivery_details   
set shipping_instructions = rtrim(shipping_instructions)  
where length(shipping_instructions) < >length(rtrim(shipping_instructions))
and organization_id=1041;

update oe_order_lines_all   set shipping_instructions = rtrim(shipping_instructions)  
where length(shipping_instructions) < >length(rtrim(shipping_instructions))
and org_id=1041;

commit;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/92289/viewspace-1712155/，如需轉載，請註明出處，否則將追究法律責任。

相關文章