Re: V9 For each loop - access element problem

Brian Mellert

Dropping the [0] would return the whole data record instead of separate fields/lines.  (I've found that hand to print contents for debug purposes.)

 

The is one item regarding foreach data objects I have found -- and believe its a major short-coming -- is that it doesn't appear you can use if visual script logic with the foreach object.  (For instance, to do separate actions depending on the value of the current row -- such as an insert verses update of another table based upon the current foreach object.)  This has forced me to create extra BOs to cover each condition separately instead of one data set with if branches.

 

I have begun trying to work with direct SQL statements in a foreach, but I'm having time-out issues I've not been able to figure out yet.  (I think they are .NET timeout issues as time-out error are returning after 110 seconds while the engine time-out is set to 600 seconds.)