PRB: MSFlexGrid Does Not Refresh When SQL Property Changes (179759)
The information in this article applies to:
- Microsoft Visual Studio 97
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.
Modification Type: | Major | Last Reviewed: | 4/18/1999 |
---|
Keywords: | kbprb KB179759 |
---|
|