Re: vb6 call recordset from sql server 2000 - working until using parameters - then empty recordset

I found out, that I am getting the data.

Do While Not Rs1.EOF
Debug.Print Rs1.Fields(0)
Rs1.MoveNext
Loop

But why cant I bind the grid directly to the recordset?

Set Me.MSFlexGrid1.DataSource = Rs1

Thanks.
aaapaul



.

Relevant Pages

  • DataReport in Visual Basic 6
    ... I would like to know if we can bind the same DataReport (Visual Basic ... Qr1 =" Select EMP_ID, FirstName, LastName from Pers where Function ... I just want to know if we can bind two different RecordSet to the Same ...
    (microsoft.public.vb.general.discussion)
  • DataReport in Visual Basic 6
    ... I would like to know if we can bind the same DataReport (Visual Basic ... Qr1 =" Select EMP_ID, FirstName, LastName from Pers where Function ... I just want to know if we can bind two different RecordSet to the Same ...
    (comp.lang.basic.visual.misc)
  • DataReport in Visual Basic 6
    ... I would like to know if we can bind the same DataReport (Visual Basic ... Qr1 =" Select EMP_ID, FirstName, LastName from Pers where Function ... I just want to know if we can bind two different RecordSet to the Same ...
    (microsoft.public.vb.crystal)
  • Re: ADO Form bind
    ... setting the control source to County makes the text not updateable that I ... I don't believe you can bind an updatable form to an ADO recordset using the Jet provider. ...
    (microsoft.public.access.formscoding)
  • Re: Bindind a listbox to a recordset using DAO in Access 2000 VBA
    ... and only to bind the list ... I know the recordset is being ... > the Listbox doesn't appear to bind itself; I end with a blank list ... > Dim wks As DAO.workspace ...
    (microsoft.public.word.vba.general)