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

Resolved Retrieve.AsNeeded Workaround in PowerServer

  1. How-to
0
Votes
Undo
  1. Alex Riofrio
    Alex Riofrio
  2. PowerServer 2020 or older (Obsolete)
  3. Wednesday, 27 January 2021 21:12 PM UTC

Hello everyone;

Please, Does anyone have a more detailed example or algorithm for the step #3 of this workaround?

https://docs.appeon.com/pb2019/workarounds_and_api_guide/ch05s04s02.html#Retrieve.AsNeeded

Thanks,

Alex

Stored procedure call 1st input argument us not su...
How to migrate AEM settings for Application
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 27 January 2021 21:53 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Alex;

  I have used the follow approach before ...

Query#1 ... 1st 10 rows - Example:

SELECT   Name,
         ProductNumber,
         StandardCost
FROM     Production.Product
ORDER BY StandardCost
         OFFSET 0 ROWS
         FETCH NEXT 10 ROWS ONLY

Query#2 ... next 10 rows - Example:

SELECT   Name,
         ProductNumber,
         StandardCost
FROM     Production.Product
ORDER BY StandardCost
         OFFSET 10 ROWS
         FETCH NEXT 10 ROWS ONLY

And so on until no more rows. Food for thought.  ;-)

Regards ... Chris

 

Comment
Alex Riofrio
  1. Alex Riofrio
  2. Thursday, 28 January 2021 00:19 AM UTC
Thank you very much Chris for the contribution.



Alex. :)
  1. Helpful
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.