PRB: DataForm Wizard List Page Doesn't Show Updated Data (184567)
The information in this article applies to:
- Microsoft Visual InterDev 1.0
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.
| Modification Type: | Major | Last Reviewed: | 4/21/2001 |
|---|
| Keywords: | kbprb kbwizard KB184567 |
|---|
|