I have created a foreach loop similar to that in http://www.codeproject.com/KB/database/foreachadossis.aspx. The variable which the foreach loop uses is an object data type. I don't know how to capture the variable value which is currently being used within the foreach loop. Does anybody have any tips?Mr Shaw

The current variable in the loop context is what you have setup on the "Variable Mappings" page of the For Each Loop editor. Teh value is "captured" in the variable, so what do you want to do next? Use the variable as you wish. You can check the variable if you want, set a break-point within the loop, and use the Watch window, dragging the variable in, or the Locals window.http://www.sqlis.com | http://www.konesans.com