Any suggestions for checking for Null when looping through a repeating table? I'm submitting integer columns to SQL that allows for null.
No need for code if you have a trigger column you can set that to some value. It will fire a rule on all rows. You can then use the rule to add a condition to check for null and set a value based on it.
True. However in my case NULL needs to be passed to the stored procedure if that column in the row of the repeating table has not been filled in. I'm trying to figure out the code equivalent for checking for NULL.
Well, you could add a trigger column and set it to (trigger != false) and then have a rule fire on each value and call your code behind.