Configure grid to display sequential records in parallel columns?

[uncleroydee]

I would like to display a recordset of 2000 +/-, single field, records in a series of grids of 4 columns by 50 rows.
But, how do I configure the grid to display the first 50 records in the first column, the second fifty records in the second column, third fifty in the third column, etc. as opposed to one column 2000 rows long? (I'm making the BIG assumption that VI will carry the format over to subsequent pages necessary to display the entire recordset.)

Thanks,

Roy

 

[palbano]

Roy,

That is not supported in the base _ScriptLibrary code. You might be able to add the support yourself.

Good luck
-pete

 

[uncleroydee]

Thanks, Pete.

 

[bryant89]

hey Roy

Let us know how you make out?

Bryant

 

[MerlinB]

There is no direct support in VI for this, but you could read the recordset data into 4 arrays, each 50 elements long. Then the output would be in a loop
<TR><TD<%Array1[n]%></TD><TD><%Array2[n]%></TD> ..etc..

As the recordset DTC remembers the 'current' record - you can page forward quite easily. Try setting the
rsData.AbsolutePosition = nRows * nCols * (nPageNumber - 1)

before reading into the arrays.