Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Retrieve.AsNeeded Implementation

  1. How-to
0
Votes
Undo
  1. Chris Butler
    Chris Butler
  2. PowerBuilder
  3. Thursday, 14 March 2024 16:32 PM UTC

Hi,

We have a few large reports in our application. I am looking to include paging so the data in these reports is retrieved on-demand. Would  Retrieve.AsNeeded would be a solution for this? (Correct me if I am wrong).

Looking at the documentation on this property, I have a few questions...

1) Proper implementation -  I would assume I need set the Retrieve.AsNeeded property before the retrieve of the datawindow. Do I need to do this in code AND in the painter? 

2) Testing - How can I test this to be sure this is working as expected? 

Any feedback and comments on this are greatly appreciated.

Thanks!

- Chris 

 

 
Powerbuilder and OneDrive access
SAP IQ Database Connection From PowerBuilder appli...
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 14 March 2024 18:33 PM UTC
  2. PowerBuilder
  3. # 1

Hi Chris;

  Note that even when this property is set, the following negates this setting & use at runtime ...  

  • Sort settings
  • Filter settings
  • Some types of computed columns
  • Group calculation(s)

  If the above settings are present, then the DWO will retrieve all the rows regardless & thus, ignore the RetrieveAsNedded. Food for thought 

Regards ... Chris 

Comment
Chris Butler
  1. Chris Butler
  2. Thursday, 14 March 2024 18:37 PM UTC
Thanks Chris. I am noticing this in my testing as well.
  1. Helpful
Chris Butler
  1. Chris Butler
  2. Thursday, 14 March 2024 19:15 PM UTC
Note for other devs... Using temp tables will also ignore the .AsNeeded property.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Thursday, 14 March 2024 16:42 PM UTC
  2. PowerBuilder
  3. # 2

1. Only setting it in the datawindow should be enough.

2. see how many rows you get when the property is not set and retrieve. Then Set the property and repeat the retrieve. When you get at the end of the retrieved rows, it should automatically retrieve another block of rows.

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.