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