Article
Muhammad Waseem · Nov 7, 2021 1m read

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

10
1 0 0 119
Log in or sign up to continue