Microsoft KB Archive/184567

= PRB: DataForm Wizard List Page Doesn't Show Updated Data =

Article ID: 184567

Article Last Modified on 4/21/2001

-

APPLIES TO


 * Microsoft Visual InterDev 1.0 Standard Edition

-



This article was previously published under Q184567



SYMPTOMS
When using code generated by the Visual InterDev 1.0 Data Form wizard, updates to a database may not be displayed when the page is refreshed.



CAUSE
The Data Form wizard xList.asp page stores the recordset object in a session variable. Under varying circumstances, this can cause undesirable caching effects. It is very easy, however, to change the code that does this.



RESOLUTION
In the Xlist.asp page, search for the following line of code: fNeedRecordset = False This line will be at about line 248. Change it to this: fNeedRecordset = True This causes the Xlist.asp page to always retrieve a new recordset object when the page is called.

To save system resources on the server, you should also change the code that places the recordset object in the session variable.

Simply comment out the last three lines of Active Server Pages (ASP) code on the page; they appear after the following comments: ' TEMP: cache here until CacheRecordset property is implemented in   '  data range



STATUS
This behavior is by design.

Keywords: kbprb kbwizard KB184567

-

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

© Microsoft Corporation. All rights reserved.