SQL Server Performance Forum – Threads Archive

Where Clause

VB6…msflexgrid 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

---

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?"

---

]]>