Gridtest.exe Sample Grid Does Not Refresh Properly

MORE INFORMATION

The following files are available for download from the Microsoft Download Center:
For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. Symptoms Under the following conditions, a grid based on two tables will not display the correct data:

• Focus is on the grid making one of the grid cells active.
• A toolbar button that skips to the next or previous record is clicked.
• The number of records in the grid exceeds the number of records that may be displayed.
• The grid is scrolled.

Whether or not the scroll thumb or the scroll arrows are used to scroll the grid determines how the data is misrepresented. In either case, the records from the second table are misrepresented.

Resolution

Here are two possible workarounds:

• In the Click events of the navigation buttons on the toolbar, set the focus on the main form to an object other than the grid. This is demonstrated in the sample file with the form called Works. An example of the code is as follows:

        _SCREEN.ACTIVEFORM.txtF1.SETFOCUS
         SELECT TBL1
         SKIP 1
        _SCREEN.ACTIVEFORM.REFRESH
  						

  (txtF1 is the name of a visible object on the form) -or-
  
  
• Create a button on the main form that executes the following code:

        THISFORM.GRID1.REFRESH
  							

  (Grid1 is the name of the grid)
  
  Executing the refresh from a button on the custom toolbar does not solve the problem.
  
  See step 6 under Steps to Reproduce Behavior for this workaround.

NOTE: If the navigation buttons are objects on the form, this problem does not occur.

Status

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.

Steps to Reproduce Behavior

1. Using the sample file run the form named Broken.
2. Click the Next button located on the form. All the visible cells in the first column of the grid should contain the number 2. Note that if the grid is scrolled with either the scroll thumb or scroll arrows, all the grid columns display correctly. The example below demonstrates how the data should be displayed in the grid. The last row will not be visible.

         TBL2.F1   TBL2.F2   TBL3.F2   TBL3.F3
         -----------------------------------------
   
         2         a         a         Red
         2         b         b         Blue
         2         c         c         Green
         2         d         d         Yellow
         2         e         e         Brown
   						

3. Click in any cell of the grid. The grid now has focus on the form.
4. Click the Previous button on the Toolbar, not the form.
5. Scroll down the grid with the scroll thumb or slider. All the records in the third column (TBL3.F2) will contain the letter "a." "Red" appears in all the records of the fourth column (TLB3.F3).
   
   Scroll down the grid with the scroll arrow. All the records in the third column (TBL3.F2) will contain the letter "d." "Yellow" appears in all the records of the fourth column (TLB3.F3).
   
   Using the scroll thumb, scroll arrows, or clicking in one of the grid cells does not cause that cell to refresh properly.
   
   NOTE: The results of this step may be inconsistent and differ from what is described here. What should be displayed is the example shown in step 2 above with the number 1 in the first grid column for all rows.
6. Make sure that the focus is not in either the third or fourth grid column, and then click the Grid Refresh button on the form. The grid should now be back to normal. If one of the cells in the third or fourth column had focus, it will not refresh, but all the others will. This step implements the second workaround described in the Resolution section above.
7. Click in one of the grid cells, and then click the Next button on the toolbar. The grid should move so that the number 2 is in the first column (TBL2.F1). The data in the third and fourth columns should be correct. Refer to the grid in step 2 above. Note that the last row is not visible.
8. Scroll the grid using the down scroll arrow. Note the values in the third and fourth columns for the first visible record when you finish scrolling.
   
   If the scroll down was stopped, with only the last two records displayed, and then the up scroll arrow is clicked, all the records displayed from TBL3 will have the correct information. The example below demonstrates how the data should be displayed in the grid.

         TBL2.F1   TBL2.F2   TBL3.F2   TBL3.F3
         --------------------------------------
   
         2         a         d         Yellow
         2         b         d         Yellow
         2         c         d         Yellow
         2         d         d         Yellow
         2         e         e         Brown
   						

   If only the last record was visible when scrolling down stopped, then all the records will contain an "e" in the third column (TBL3.F2) and "Brown" in the fourth column (TBL3.F3) of the grid when scrolling up.
9. Modify the GridTtest.pjx sample project and examine the code in the forms and visual classes.