BUG: Recordset Commands Must Wait Until the Ondatasetcomplete Event Fires (190594)

MORE INFORMATION

Wait until the ondatasetcomplete event fires to use the results from the newly opened recordset. For example:

   <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 under the following conditions:

• The database object (table, view, and so forth) is large.
• The client computer is fast.
• The connection to the database server is slow.

1. Create a project.
2. Add a data connection.
3. Add an HTML page.
4. Place a recordset DTC, a text box DTC, and a button DTC on the page.
5. Bind the recordset DTC to a database object.
6. Add an event for Button1_onclick as follows:

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

7. Browse to the page, and click the button.