FIX: Page Not Refreshed When You Point to a Deleted Record

This article was previously published under Q190753
This article has been archived. It is offered "as is" and will no longer be updated.
If you choose to delete a record on an Active Server Pages (ASP) page, whenthe record has been already deleted by another user, the page is notrefreshed to indicate that the record was already deleted.
You can work around this by checking for the return value of the deleteoperation. DeleteRecord() function returns false if the operation failed.If you want to see the new data, you need to catch the return code and do amove on the recordset.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Visual Studio 6.0 Service Pack 3. For more information about Visual Studio service packs, please see the following articles in the Microsoft Knowledge Base:
194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 HOWTO: Tell That Visual Studio 6.0 Service Packs Are Installed
Sample code to illustrate the work around mentioned above:
   Sub Button1_onclick()     if  not Recordset1.deleteRecord() then   Recordset1.move(0)     end if   End Sub				

Article ID: 190753 - Last Review: 10/09/2013 20:05:18 - Revision: 1.2

Microsoft Visual InterDev 6.0 Standard Edition

  • kbnosurvey kbarchive kbbug kbfix kbvs600sp3fix kbwebserver KB190753