Skip to main content

Hi Experts,

Is it possible to set a null value with an xml update?

ex: 
update task set person_id=null where task_id=123

how to do this with an xml?
I tried the following but didn’t work

<update_task>
  <task>
    <task_id>123</task_id>
    <person_id></person_id>
    <update />
  </task>
</update_task>

I have a vague memory that you need to use = to set null. 
 

<update_task>
  <task>
    <task_id>123</task_id>
    <person_id>=</person_id>
    <update />
  </task>
</update_task>

 

Reply


Terms & ConditionsCookie settings