One Star

Feed tForEach dynamically

Hi
I would like to know if we can feed dynamically tforeach based on TMSSqlInput.
1. tMSSqlInput result need to feed the tForEach values ?
2. Could we use a contextvalirable with a list of values for tForEach?
3 REPLIES
One Star

Re: Feed tForEach dynamically

Hi
If you want to iterate the according to the records in the select Query in tMSSqlInput you can use tFlowIterate
One Star

Re: Feed tForEach dynamically

Thx Lijo for your response but how do you get the result of the query
exemple
I have a TMSSqlInput with query like "select NAME from clienttable where age <30" I would like to have a messagebox alerte with the response of the query
how do you do?
DN

Re: Feed tForEach dynamically

tMSSqlInput--->tFlowToIterate-->tMessageBox
in the message box, to reference data from your mysql input:
globalMap.get("<row>.<column_name>")

The row varible is the row input to your tFlowToIterate.