FIX: Invalid Operation When Deleting the End Sybase Record

ID: Q168273

The information in this article applies to:

SYMPTOMS

The following error occurs when deleting the last record of a Sybase table using the "Delete" button on a DataForm Wizard generated form:

Invalid Operation


The delete succeeds on the Sybase table.


CAUSE

The DataForm Wizard generated code executes a "MovePrevious," which is not allowed for Sybase tables.


STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This bug has been corrected in Visual Studio 97 Service Pack 1.

For additional information about the Visual Studio 97 Service Pack 1, please see the following article in the Microsoft Knowledge Base:

Q170365 INFO: Visual Studio 97 Service Packs - What, Where, and Why


MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a web project with a connection to a Sybase database.


  2. Run the DataForm Wizard.


  3. Preview xxxForm.ASP in the browser.


  4. Move to the last record.


  5. Choose Delete.


Results: Error : Invalid Operation

Additional query words: 


Keywords          : kb3rdparty kberrmsg kbADO kbVisID100 kbVisID600fix kbVS97sp1fix kbVS97sp2fix kbGrpASP 
Version           : WINDOWS:1.0
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: April 6, 1999