Question
Bank Frick
LI
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
Bank Frick
LI
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.
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.