Hi.
For some reason an update button on my canvas app works only some of the times. The issue seems to be that sometimes a couple of string variables are passed to my SQL database as "" and sometimes as null. I can see this by looking at the monitor (patchExistingRow).
When the variables can be seen as empty strings (""), the update fails due to a foreign key issue (these strings are foreign keys on my SQL table). I have not been able to find the cause of this varied behaviour but I did try to pass the values as just Blank() and even that seems to cause these fails. Is there any way I can guarantee that string variables would be passed as null and not empty strings, as it looks like that could fix the issue? As I said, Blank() seems not to be working how I would need it to work.
