BUG: VB 6.0 Stops Responding if ADO DataControl References fMoreData in EndofRecordset Event

ID: Q236941


The information in this article applies to:
  • Microsoft Visual Basic Professional and Enterprise Editions for Windows, version 6.0
  • ActiveX Data Objects (ADO), versions 2.0, 2.1, 2.1 SP1, 2.1 SP2, 2.5


SYMPTOMS

When the fMoreData argument is referenced in the DataControls EndofRecordset method, Visual Basic stops responding.


RESOLUTION

  • Do not reference fMoreData in code.

    -or-


  • Do not use the DataControl. Instead use ActiveX Data Objects (ADO) code, declaring your recordset using WITHEVENTS.



STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a new Standard EXE project.


  2. From the Project menu, choose Components and select the ADO Data Control.


  3. Place the ADO Data Control on the form.


  4. Set the ADO Data Control ADODC Connectionstring property to a valid Datasource. Also, set the Recordsource property.


  5. Place a text box on the form.


  6. Set the DataSource property of the text box to the ADO Data Control.


  7. Place the following code in the ADODC1's EndofRecordset event:


  8. Debug.Print fMoreData 
  9. Save the Project.


  10. Close and exit Visual Basic.


  11. Start Visual Basic and reopen the Project.


  12. Press F5 to run the form.


  13. Click the Previous button on the ADO Data Control.


  14. RESULT: Visual Basic stops responding and no error appears.


REFERENCES

(c) Microsoft Corporation 1999, All Rights Reserved. Contributions by Terrell D. Andrews, Microsoft Corporation.

Additional query words:

Keywords : kbADO kbDatabase kbGrpVBDB kbGrpMDAC kbDSupport
Version : WINDOWS:2.0,2.1,2.1 SP1,2.1 SP2,2.5,6.0
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: January 7, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.