June 15, 2010 at 10:53 am
Hi all,
Firstly I'm new to the ForEachLoop container so please forgive any silly questions.
Basically I want to loop over a record set which contains a series of records detailing a procedure name and a file name, these will then be used else where in the container.
How do I go about doing this? I was thinking it's just a case of setting the container to use the Foreach ADO Enumerator and then providing it with a recordset but this obviously doesnt work, or I'm missing the point (more than likely), as I cant define the dataset.
Can some one give me some pointers as to how I can acheive the above?
Many thanks,
Nic
June 15, 2010 at 10:56 am
You might take a look at this link to start http://www.codeproject.com/KB/database/foreachadossis.aspx
CEWII
June 15, 2010 at 10:57 am
Many thanks,
I'll have a read of it now.
Nic
June 15, 2010 at 12:31 pm
You are very welcome.
CEWII
June 16, 2010 at 3:09 am
Hi again,
The only issue I have now, is that my object variable (used for the loop container) contains a UID for each row of data, how do I get his out to pass into a procedure as I'm getting data type binding errors, presumably because the datatype for the variable is 'object'?
Any help would be appreciated.
Thanks,
Nic
June 16, 2010 at 4:11 am
Ignore that sorry, I'd not set up the variable mapping correctly.
All works a treat now.
Many thanks,
Nic
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply