Question
Soprasteria
CH
Last activity: 18 Nov 2017 2:07 EST
How to loop the results which is fetched from the ODBC Data Component
Hi Team,
I would like to know how to loop the results fetched from the ODBC Data Component
1. Created the sample Table in the MS Access DB.
2. From Robotics Automation able to query the results from the table.
3. I extracted the proxy from the results, but i dont know how to get the desired value from the results.
Thanks
Pegasystems Inc.
US
Use GetTable
http://help.openspan.com/80/Components/ODBC_Query.htm
Pass it to a datagrid
http://help.openspan.com/80/Components/Using_the_ODBC_Query_Component.htm
Use the grid to pull out data line by line.
http://help.openspan.com/80/Components/Data_Grid_-_Property,_Method_and_Event_Exceptions.htm
Soprasteria
CH
DataGrid control is used display the results in the Window form, but here my requirement is not to show the records in the Window form rather it be in the memory and able to proceed further automation on the each record.
Pegasystems Inc.
US
Can you work on it directly behind the scenes by just pulling the records into your automation as a property of the control they're on?
Infosys
IN
Hi,
Extract proxy of result and take rows property then extract proxy, it will contain row and columns. Please check all properties of each extracted proxy and then explore.