PRB: Listbox DTC Does Not Show Changes When Bound Recordset Changes (229701)

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a new project in Visual InterDev 6.0.
2. Add an Active Server Page (ASP) page (Asp1.asp) to the project.
3. Create a Data Connection (Connection1) to the NorthWind Database, Nwind.mdb.
4. Add a Recordset DTC (Recordset1) to the page.
5. Set the properties of the Recordset to use Connection1, and use the Employees table.
6. Add a Listbox DTC (Listbox1) to the page.
7. Right-click Listbox1 and select Properties.
8. On the General tab, set the Recordset property to Recordset1 and the Field property to the EmployeeID field.
9. Click the Lookup tab.
10. Select the Recordset option.
11. Set the Rowsource to Recordset1.
12. Set the ListField and the Bound Column each to the EmployeeID field.
13. Click OK.
14. Add a Button DTC (Button1) to Asp1.asp
15. When the button is clicked the recordset is changed by using the recordset.setSQLText method. Add the following code to Asp1.asp to run for the onclick event of Button1.

    <%
    Sub Button1_onclick()
        strSQL = "SELECT * FROM employees WHERE EmployeeID > 4"
        If Recordset1.isOpen() Then Recordset1.close 
        Recordset1.setSQLText strSQL
        Recordset1.open
    End Sub
    %>
    						

16. Save the Asp1.asp file.
17. Right-click Asp1.asp and select View in Browser.
18. Click Button1.
19. This re-queries Recordset1 so it returns only records where the value of the EmployeeID field is greater than 4, but Listbox1 does not reflect the changes.

<%
Sub Button1_onclick()
    strSQL = "SELECT * FROM employees WHERE EmployeeID > 4"
    If Recordset1.isOpen() Then Recordset1.close 
    Listbox1.clear
    Recordset1.setSQLText strSQL
    Recordset1.open
End Sub
%>