Microsoft KB Archive/179759

= PRB: MSFlexGrid Does Not Refresh When SQL Property Changes =

Article ID: 179759

Article Last Modified on 4/18/1999

-

APPLIES TO


 * Microsoft Visual Studio 97 Service Pack 3

-



This article was previously published under Q179759



SYMPTOMS
If the customer has an MSFlexGrid on a form that is bound to a RemoteData Control(RDC), and if the recordset of the control is changed (for example, by changing the SQL property of the RDC), the records displayed in the grid are from the original recordset, not the new one. Refreshing or repainting the grid does not help.



CAUSE
When a control like this is bound to a data source, it gets an ICursor to give it access to a cursor with the data. When the recordset changes, an event is fired that tells the bound control that the data has changed. The control then frees up the old cursor and grabs the new one. The MSFlexGrid appears to be ignoring the change event when it fires.



RESOLUTION
The best workaround is to use the DBGrid control included with Visual Studio instead.

If you must have a control that shows the new recordset after the RDC changes, then the only other option is to find a third party control that does this.



STATUS
Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: FlexGrid Refresh Update Datasource SQL

Keywords: kbprb KB179759

-

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

© Microsoft Corporation. All rights reserved.