SQL Server Performance

Where Clause

Discussion in 'General DBA Questions' started by Morgan, Jan 9, 2003.

  1. Morgan New Member


    Sub DoSql()
    Dim mysql$
    mysql = "SELECT Authors.AuthorNumber, Authors.TitleNumber, Titles.Title " & _
    "FROM Authors INNER JOIN Titles ON Authors.TitleNumber = Titles.TitleNumber "
    Data1.RecordSource = mysql
    End Sub

    This works perfect and it inner joins the two tables but i want to be able to browse the recordset one record at a time. As you can see this pulls all records. Also i want it to work on movenext...etc.

    Thank you....Morgan
  2. royv New Member

    Use the ADO Data bound control in VB6. That will edit record by record and provide all the properties necessary to navigate through the data

    "How do you expect to beat me when I am forever?"

Share This Page