FIX: Invalid Operation When Deleting the End Sybase Record

• Microsoft Visual InterDev, version 1.0

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

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