Code

Re: Error Checking in VB code for NULL when looping through repeating table

Patrick Halstead — Sun, 01 Sep 2013 22:45:13 GMT

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.

Re: Error Checking in VB code for NULL when looping through repeating table

pfiggatt — Mon, 26 Aug 2013 19:06:22 GMT

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.

Re: Error Checking in VB code for NULL when looping through repeating table

Patrick Halstead — Mon, 26 Aug 2013 18:36:32 GMT

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.

Error Checking in VB code for NULL when looping through repeating table

pfiggatt — Mon, 26 Aug 2013 15:02:06 GMT

Any suggestions for checking for Null when looping through a repeating table? I'm submitting integer columns to SQL that allows for null.