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>
Solved
Set null value using xml update
Best answer by anmise
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>
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>
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.