Is this possible? Basically the token shows a warning if I enter %(DB.NULL) in the value. I have to type this as it is not available in the list of token choices.
We need to write NULL values to a database if certain fields on a submitted form are empty. This means that we have to check each one and we would certainly want to stay away from lots of Update Datas or Inserts. Basically I have a Parallel that is checking all the tokens if they are empty or not. Below is just two:
If the field submitted is empty, we update the token with DB.NULL. If it is not empty, we update the token to hold whatever the value submitted was. After this parallel is when we do our Insert to the database and I want to use the token values. However DB.NULL is not a choice and when I try and publish I get an error about "Cannot implicitly convert type 'string' to 'System.Workflow.Activities.SequenceActivity'". I assume this is because the token is marked as a string
Anyone know how to write NULL to a db from a token? Otherwise we are going to have two update data's for each possible field.
Thanks,
Chris