Cant assign Memory to flex Grid

[Silly Star]

Hi......

i am using a grid with 8 columns and lots of records (more than 32,767)
nd getting an error " Cant assign memory to flexgrid"

i cant remove or replace grid with other controls at this stage

Has any body faced situtation like this????

Any work done for situation like this nd help will be greatly appreciated.

Thanks for everything in advance.

Silly Star

[Cimperiali]

usually you should not need to load the whole records in a grid.
Grid is for humans, and humans should not be able to see more than
-say- 20records per time. You could load even to 1000, but in any case
page.
That is: build your recordset to retrieve -say- 100 records per page, and
load till -say- 10 pages. THen go on with 1000 more, but forst clear grid with
previous...You can have buttons to go haead or back, and can use a custom
"find" to let user drop nearer to what he is looking for....

[Silly Star]

Thanks Cimperiali

thats what i was thinking about.
but to me it was difficult to know that how to handle Paging.
actually i am working on Financial Management System of a company.
i encountered this problem in generating the activity report, which include
Opening Balance and Closing balance for that activity.

i was troubled by "Navigation".
But the great idea of using buttons for navigation would surely get me out of trouble.

Thanks a lot for ur kind Openion.
nd looking for further assistance and help to give me more ease in handling this matter.

Silly Star

usually you should not need to load the whole records in a grid.
Grid is for humans, and humans should not be able to see more than
-say- 20records per time. You could load even to 1000, but in any case
page.
That is: build your recordset to retrieve -say- 100 records per page, and
load till -say- 10 pages. THen go on with 1000 more, but forst clear grid with
previous...You can have buttons to go haead or back, and can use a custom
"find" to let user drop nearer to what he is looking for....