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?
Best answer by Praveen123
View originalHi Praveen123,
May I please know on what do you mean by not working ? Is there any error shown ?
Cheers,
Kate
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.
Thanks for replying. Unfortunately, in my case it's not a Memo type but a File Content type.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
