I am using ADO 2.1 and use the recordset.getstring method to populate my
flexgrid
Its fast and extremly handy when not using bound grids. But I am facing a
strange problem
When the recordset has a few hundred records, there isnt any problem
But when the records exceed a few thousand, some of the records spill out
into more than one row
I am have not been able to figure out the reason
Any Ideas ???
Here is an example of what I do
Dim rsVar as variant
rsVar=rst.getstring(adClipString, rst.recordcount)
' assume rst to be a open recordset with > 0 records , cursortype static,
source is a table
With fGrid
.rows=rst.recordcount+2
.Cols = rst.Fields.Count + 1
set rst = nothing
.Row = 1
.Col = 1
.RowSel = .Rows - 1
.ColSel = .Cols - 1
.Clip = rsVar
.RowSel = .Row
.ColSel = .Col
End with
What is the problem ? Why does it work with lesser records
Thanks for any light u can throw into this
Regards,
Mujahid