Hi Friends please someone help me on the below issue.
I have a SQL query which I ran in STRSQL. Initially it's showing 17 records in first page and pressed Page down to go to 2nd page then it's showing second set of 17 records. And then If I press page up to go to 1st page again I could see that the first record in the first page is getting duplicated. And I have checked the file, there are no duplicate records in it. I am not able to understand why it's not showing any duplicate records initially, but it's showing duplicate records when I do a page down and page up.
And the actual problem is, we are using the same query as a CURSOR to display the records in a Single page subfile. Initially I thought it's a PAGEUP, PAGEDOWN issue with the Subfile, but I have debugged the program so many times and could see that the cursor itself fetching the duplicate data and displaying the same in subfile.
Note: We are using a Join logical file in the cursor. And we are facing this issue in first time access only. If you run the Query once in STRSQL and came back and you run it again we are not able to replicate the Scenario.
I haven't seen this type of behavior of a Query before. And no one in my team faced this type of issue before. And some one saying that it’s some SQL package issue.