passing arrays from vb dll to vb form
You might have better luck with RS.GetRows(). It's faster, uses less
code, and gives the field names as well as values.
Check it out in the MSDN...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado2...
HTH
- Rick
Quote:
> after the RS.OPEN.....
> X = rs.recordcount
> redim Arr(x)
> if x > 0 then
> rs.movefirst
> do while rs.eof = false
> ' move the data into the array
> arr(rs.absoluteposition) = rs.fields("NAME")
> rs.movenext
> loop
> end if
> > hi all,
> > I am new to vb programming. i want to write
> > functions in vb dll which takes some parameters in one
> > dimensional array from vb form and from the dll the
> > function has to insert the data retrieved from array in
> > the database. Another function is return back all the
> > records in a table in the form of 2 dimensional array.
> > The easy way is using recordset as perameter. But i want
> > to send back all the records in 2 dimensional arrays. How
> > to do it. Can anybody suggest guide me to write the dll.
> > with regards,
> > vali
