PRB: MSFlexGrid Does Not Refresh When SQL Property Changes

• Microsoft Visual Studio versions 97, 97sp3

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.