BUG: Recordset Commands Must Wait Until Ondatasetcomplete

ID: Q190594

The information in this article applies to:

Microsoft Visual InterDev, version 6.0

SYMPTOMS

You may see the following error appear:

A Runtime Error has occurred.
Do you wish to debug?

Line 630
Error: The operation requested by the application is not allowed if the object is closed.

This error is most likely to occur on a DHTML page and will happen most often with large database objects.

CAUSE

The recordset is not fully loaded in memory at this point.

RESOLUTION

Wait until the ondatasetcomplete event fires before continuing.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Wait until the ondatasetcomplete event to use the results from the newly opened recordset, like this:


   <SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript>
   <!--
   function Button1_onclick() {

      Recordset1.open();

   }

   function fillValue()  {
      Textbox1.value = Recordset1.fields.getValue(0);
   }

   function Recordset1_ondatasetcomplete() {
      fillValue();
   }

   //-->
   </SCRIPT>

Steps to Reproduce Behavior

The following steps will normally produce this error. The error is more likely to occur when the following are true:

The database object (table, view, and so forth) is large.

The client machine is fast.

The connection to the database server is slow.

Create a project.

Add a data connection.

Add an HTML page.

Place a recordset DTC, a text box DTC, and a button DTC on the page.

Bind the recordset DTC to a database object.

Add an event for Button1_onclick:


      function Button1_onclick() {
         Recordset1.open();
         Textbox1.value = Recordset1.fields.getValue(0);
      }

Browse the page and click the button.

Additional query words:

Keywords : kbADO kbVisID600bug kbGrpASP
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbbug