Offset functionality in Progress 10.2B

Posted by Jyoti Sharma on 09-Dec-2016 06:19

Hi,

I need to use limit and offset functionality in progress database (version 10.2B). I know that for limit, we can use TOP in query.

But how can I implement offset functionality in query?

OpenEdge Development - Forum
Posted by Dileep Dasa on 09-Dec-2016 06:35

SQL OFFSET and FETCH clauses were introduced in OpenEdge 11.2. These are not available in 10.2B.

There is an equivalent ABL code here. But I think you are looking for a SQL solution. 

You might find some SQL solution here 

All Replies

Posted by Dileep Dasa on 09-Dec-2016 06:35

SQL OFFSET and FETCH clauses were introduced in OpenEdge 11.2. These are not available in 10.2B.

There is an equivalent ABL code here. But I think you are looking for a SQL solution. 

You might find some SQL solution here 

Posted by Jyoti Sharma on 12-Dec-2016 23:41

Hi Dileep,

Is this possible that I write the ABL code and when I execute the SQL query from my application, the ABL code also executes with it? So that the offset/fetch ABL code runs with the SQL query.

Posted by Dileep Dasa on 14-Dec-2016 01:37

No, it is not possible that way!

This thread is closed