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

Ah, same here. Geez, I must be getting old.

William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
Visit to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message news:OKW%23mSaCIHA.3940@xxxxxxxxxxxxxxxxxxxxxxx
aaapaul wrote:
I found out, that I am getting the data.

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

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

Set Me.MSFlexGrid1.DataSource = Rs1

Sorry, but it's been too long since I used vb6, and even when I did, I never bound my grids to data sources, preferring to fill them myself. You will probably get better response to this in a VB6 group such as microsoft.public.vb.general.discussion

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the


Relevant Pages