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

The information in this article applies to:

Microsoft Visual InterDev 6.0

This article was previously published under Q190753

SYMPTOMS

If you choose to delete a record on an Active Server Pages (ASP) page, when the record has been already deleted by another user, the page is not refreshed to indicate that the record was already deleted.

RESOLUTION

You can work around this by checking for the return value of the delete operation. 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 a move on the recordset.

STATUS

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

MORE INFORMATION

Sample code to illustrate the work around mentioned above:

   Sub Button1_onclick()
     if  not Recordset1.deleteRecord() then
   Recordset1.move(0)
     end if
   End Sub

Modification Type:	Minor	Last Reviewed:	3/7/2005
Keywords:	kbBug kbfix kbVS600sp3fix kbWebServer KB190753