Strange row repeat issue in query second page grid

swiftinitpvtltd

Getting Strange row repeat issue in query second page grid.
I have a standard simple query and with 5 items per page settings what is happening for few queries is when you have 7 items 1st item gets shown in second page as second row item again. Has anyone seen this type of issue?

1
2
3
4
5

second page click
6
1

BLOMASKY

I have not, but I am curious, do you have a sort on the query and is it determinative ?

Bruce

tford

What do you mean by determinative, Bruce?

BLOMASKY

Means that you would get the same sort order each time you run the query. Example. If you have an employee table with an attribute for Sex, and you sorted JUST on Sex, you would get all the females first, then the males. However, within the sex, there would be no guarantee as to the order. If you added the employee # to the sort, then each time it would sort the same way.

Bruce

tford

Ahh, makes sense Bruce.

swiftinitpvtltd

thank you Both. Wow. That was it. Great catching this small thing Bruce. I had an order by that was doing this.