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

aaapaul wrote:
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

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
"NO SPAM"


.

Relevant Pages

  • Re: Wanna any idea to generate an ID
    ... a recordset with a pessimistic lock (this is pretty much the ... ASP) can be used to retrieve and increment the value: ... CREATE TABLE NextID ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: ERROR with command text
    ... I'm not sure why you would think I would hate it. ... unnecessary recordset object when your run a query that returns no records ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: What to use for ADO parameter type and size
    ... Yes, leaving off the Set was a typo, but it worked fine tough. ... I think I do need the recordset as I need to move the data to a SQLite ... Maybe a nanosecond faster. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Accessing data from an MS Access database on a remote web serv
    ... updatebatch statement there. ... simple update on the recordset in the calling page since it's disconnected ... disconnected your recordset in the first place. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: MORE sql Query
    ... A single connection can be re-used ... The first field in the recordset has an ordinal position of zero, ... So you can use rsto refer to it. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)