msflexgrid/mshflexgrid

[suvipra]

Hi,
Does anybody have any idea about the maximum of rows and/or cols one can have in msflexgrid/mshflexgrid ?.I am trying to open a msflexgrid/mshflexgrid control based on the number of records in two different tables,as rows and cols respectively.The error I get is 'subscript out of range' or 'unable to allocate memory'(My rows are about 25000).Does anybody have a better suggestion?.Any help would be highly appreciated.
Thanks.

[ufo]

It depends on your computer configuration but number of cols are always limited. But you can solve your problem with huge amount of rows. You need to open recordset as ServerSide cursor then e.g. SQL Server will send you only thouse rows which you are able to show in grid in specified position which means 20 rows or so.
This is only way how to open large recordsets and doesn't matter how many MB of ram your computer actually have.


[ufo]