Question4Replies590Views×Close popoverSom Venkata Kumar Rallapati (Som@Soprasteria) Soprasteria Consultant Soprasteria CH View ProfileSend Message Som@Soprasteria Member since 2011 16 posts Soprasteria Posted: October 30, 2017Last activity: November 18, 2017Posted: 30 Oct 2017 9:35 EDTLast activity: 18 Nov 2017 2:07 EST Closed How to loop the results which is fetched from the ODBC Data ComponentHi Team,I would like to know how to loop the results fetched from the ODBC Data Component1. 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 Robotic Process Automation ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoPosted: 2 Nov 2017 0:23 EDT×Close popoverAndrew Grondin (grona) PEGA GCS Solutions Engineer I Pegasystems Inc. US View ProfileSend Messagegrona PEGA replied to Som@SoprasteriaUse 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 Posted: 3 years agoPosted: 2 Nov 2017 10:49 EDT×Close popoverSom Venkata Kumar Rallapati (Som@Soprasteria) Soprasteria Consultant Soprasteria CH View ProfileSend MessageSom@Soprasteria Soprasteria replied to gronaDataGrid 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. Posted: 3 years agoPosted: 17 Nov 2017 16:07 EST×Close popoverAndrew Grondin (grona) PEGA GCS Solutions Engineer I Pegasystems Inc. US View ProfileSend Messagegrona PEGA replied to Som@SoprasteriaCan 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? Posted: 3 years agoPosted: 18 Nov 2017 2:07 EST×Close popoverJayachandra Reddy (Jayachandra Reddy K) Infosys Infosys IN View ProfileSend MessageJayachandra Reddy K Infosys replied to Som@SoprasteriaHi, 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.