Microsoft KB Archive/179199

= BUG: Grid Based on .QPR File Appears Blank in Visual FoxPro 5.0 =

Article ID: 179199

Article Last Modified on 8/25/1999

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q179199



SYMPTOMS
Running a form that contains both a grid and a list box or combo box that have the RowSource property set to the same .qpr file causes the grid to appear empty. This behavior does not occur in Visual FoxPro 3.0b.



RESOLUTION
In the Activate event of the form, set the RowSource of the grid to itself. For example: ThisForm.Grid1.RecordSource=ThisForm.Grid1.RecordSource



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.



Steps to Reproduce Behavior
 Open the Orders table located in the \Samples\Tastrade\Data folder.  Create a file called Ztest.qpr (make sure the extension is .qpr) that contains the following code: SELECT order_id, cust_id FROM orders INTO CURSOR temp  Create a form called Ztest and add a Grid object to the form.  Set the following properties of the grid: RecordSource=Ztest.qpr RecordSourceType=3-Query (QPR)   Add a List box object to the form and set the following properties: RecordSource=Ztest.qpr RecordSourceType=4-Query (QPR)  Run the form and note that the grid is empty.</li></ol>

In Visual FoxPro 3.0b, both the grid and the list box appear populated with data.

Additional query words: kbvfp500 kbvfp600

Keywords: kbbug KB179199

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.