Micro Focus QTP (UFT) Forums

Full Version: How to give comma seprator when RS is returned multiple results?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Friends,

I am beginner for QTP. please help me and guide me to reach my goal.

Code:
My RS - ' Test1 = Connect.Execute ("select EMPID from EMPTBL")'
datatable.value("ABC",dtlocalsheet)

Question: i am getting multiple results for the EMPID column. i want to give comma seprator for each result and write in Datatable . How can i script it?
guide me if my way of scripting is wrong to get the multiple results.

Result: i am getting the result and dttable value like 101102103104105 but i want the value like 101,102,103,104,105


Thanks in advance
Prasanna