BUG: Data Control NoMatch Equals True Returns Error (192143)

Microsoft Visual Basic Enterprise Edition for Windows 5.0

Microsoft Visual Basic Enterprise Edition for Windows 6.0

This article was previously published under Q192143

SYMPTOMS

When the NoMatch method of the Data Control returns "True," the Seek method will report a run-time error "No Current Record."

RESOLUTION

The user can work around this problem by trapping the Data Control's error event and repositioning to an existing record after the seek failure.

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

Create a Standard EXE in Visual Basic. Form1 is created by default.
Place a DataControl, Label, and CommandButton on the form.

Set the following Properties of the controls:

      DataConrol(Data1)
      [DatabaseName]   :Biblio.mdb
      [RecordsetType]  :0 - Table
      [RecordSource]   :Authors

      Label(Label1)
      [DataSource]     :Data1
      [DataField]      :Author

Add the following code to the CommandButton's Click event:

      Private Sub Command1_Click()

       Data1.Recordset.Index = "PrimaryKey"
       Data1.Recordset.Seek "=", 0     'so that NoMatch=True
       Print Data1.Recordset.NoMatch

      End Sub

Press the F5 key to execute code, and note that the "No Current Record" error is returned on the Seek method.

REFERENCES

For more information about the Data Control and the Seek method, please refer to Online Help that is provided with Visual Basic.

Modification Type:

Minor

Last Reviewed:

1/8/2003

Keywords:

kbbug KB192143