|
Hi Luke,
I have created a custom field called ProductInfo. The thing is that it should not be null when running a SQL XML.modify ..... command.
Do you have a SQL comment to update a custom field.
I run this command and it does not work.
update DSC_Product
set CustomFields.modify('replace value of (//ProductInfo/@value)[1] with '''AAAAAAAAAAA''')')
where sku = 123456
It shows 1 row affected but no data updated on custom filed. The only way is by admin and it is a time consuming job.
How does update customfield works on admin and not from SQL server MS
Thanks
|