- Saravanakumar Thangapandian
- PowerServer 2020 or older (Obsolete)
- Friday, 5 July 2019 04:24 PM UTC
Hi,
I'm using Power Builder Version 2017 R3 Build 1858.
Can anyone clarify the difference between object.data and rowscopy method.
In our project, there is a complicated data window object. Select query has few oracle function and has many tables join.
There is around 1000+ rows retrieved.
When the below line is executed, it is executing very fast in desktop version, but in web version it is taking around 5 mins.
dw_2.object.data = dw_1.object.data
But if I modified to rowscopy as below, it is executing very fast in both desktop and web version.
dw_1.rowscopy(1, dw_1.rowcount(), Primary!, dw_2, 1, Primary!)
So, what is the difference between these 2 methods. Can anyone elaborate?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.