I have a SMO backed by a DB Table, and I'm trying to set the value of one of the columns to null using Update method but it's not working. I'm doing this from within Workflow and setting the value to EmptyString function.
So what's the workaround?
Solved
How to set columns to null via SMO update?
Best answer by Praveen123
Thanks Kimberly. That's what I noticed when I used GetFileFromContent function and passed empty text in content. Looks like we will have to use stored proc or trigger in DB to nullify the column value.
Thank you both - Kate and Kimberly - for responding to my query.
Hi Praveen123,
May I please know on what do you mean by not working ? Is there any error shown ?
Cheers,
Kate
It's not updating to null or not clearing the value in DB. I'm also setting another field with different value in same update call and that is getting updated correctly. The column under question is FileContent type in SMO if that helps.
Hi
If the file attachment is saved as scnull, it will be stored in the database as the following:
<file><name>scnull</name><content>scnull</content></file>
That means you will not be able to retrieve the file attachment to be displayed on your Form. Please take note of the impact of doing so.
Cheers,
Kimberly
K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.
Thanks Kimberly. That's what I noticed when I used GetFileFromContent function and passed empty text in content. Looks like we will have to use stored proc or trigger in DB to nullify the column value.
Thank you both - Kate and Kimberly - for responding to my query.
Hi,
In your workflow you can call your SMO to update your database to set your column to null like this :
I tried and it worked for me.
Note: I'm working on K2 5.1. What's your version ?
Michel From Flow Factory
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.