Question
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
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.
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?
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.
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