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

ID: Q184567

The information in this article applies to:

Microsoft Visual InterDev, versions 1.0, 6.0

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.

Additional query words:

Keywords : kbwizard kbADO kbASPObj kbVisID kbVisID100 kbVisID600 kbGrpASP
Version : WINDOWS:1.0,6.0
Platform : WINDOWS
Issue type : kbprb