Retrieving data from Caché with Appeon PowerBuilder by using ODBC

In my previous article I demonstrated the steps to connect to Caché from Appeon PowerBuilder by using ODBC.
In this article I will demonstrated how to Retrieve data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC



I am using Company.cls from Samples-Data (https://github.com/intersystems/Samples-Data/tree/master/cls/Sample) 

So Let's start:

Step 1 : First of all we need to establish a connection (https://community.intersystems.com/post/connecting-cach%C3%A9-appeon-pow...)

Step 2 : We need to create datawindow object which will link to Company class.

From File menu select New and select Grid datawindow object from DataWindow Tab
 

Step 3 : Select SQL Select from data source list

Step 4 : Select sample.company from Tables list

 

Step 5 : Select desired columns from column list and press Return

 

Step 6 : This will open a design view. Save the datawindow as d_company after desired adjustments

Step 7 : In the window control add datawindow object(d_company) which we already created to datawindow control

Step 8 : Now all we need is to call datawindow control Retrieve() function after setting the transaction object

That's it.

Below is the final snapshot after retrieving Caché data with Appeon PowerBuilder by using ODBC

Thanks