Question
1
Replies
306
Views
Posted: June 4, 2016
Last activity: June 6, 2016
Indices of page list
Experts,
What determines the indices of a page list ?
Page (1)
Page (2)
When we retrieve a page list in the clipboard, what determines which page comes on Page 1 and which one in page 2?
Well, it depends on the way you are retrieving data. Is it using Obj-Browse, ListViews, Report Definition? Are you specifying any sort order? In general, if you do not specify 'ORDER BY' clause in SQL query, RDBMS does not guarantee that your list will be returned in certain order. In PRPC, for instance, if you do not specify 'Sort' order in Obj-Browse, SQL query is generated without ORDER BY clause thus the order is never guaranteed. It may come in the order in which records are stored in disk or it may depend on how the table is indexed. It may even vary based on the columns being searched upon in WHERE clause.