PRB: RDC Refresh Method Failure with Bound DBListbox (154817)
The information in this article applies to:
- Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows 4.0
This article was previously published under Q154817 SYMPTOMS
If you change the SQL Property of a Remote Data Control with a bound
DBListbox at run time, the refresh method doesn't show the changes in the
DBListbox as it does for other controls. The Refresh method must be
called twice.
RESOLUTION
Refresh the remote data control twice. Replace the Command1_Click in the
previous sample with the code below:
Private Sub Command1_Click()
' Restrict the SQL to display only the authors whose last name
' start with an R
MSRDC1.SQL = "SELECT * FROM Authors WHERE AU_Lname LIKE'R%'"
MSRDC1.Refresh
MSRDC1.Refresh
End Sub
STATUS
Microsoft is researching this problem and will post new information here in
the Microsoft Knowledge Base as it becomes available.
REFERENCES
Building Client / Server Applications with Visual Basic Chapter 11.
Modification Type: | Major | Last Reviewed: | 6/28/2004 |
---|
Keywords: | kb32bitOnly kbprb KB154817 |
---|
|