VBFlexGrid Control (Replacement of the MSFlexGrid control)

[Nouyana]

You misunderstand the approach somehow, because it's not Krools responsibility to "automatically limit the record-amount"

I didn't say the "automatically" word. I just asked him to help.

If you want "paged mode", then it's up to you, to limit the amount of Records
(which you select from a given Table) - via proper SQL-instructions:
- either via Where-Clause (Select <FldList> From Table Where ID > LastPagedID)
- or better, in conjunction with a Top-Clause (Select Top 10000 <FldList> From Table Where...)

Yes, something like this. The problem here will arise at the time of moving through the grig, deleting or editing records. Do you have any working example?

The only possibility I see here in order not to make mistakes is to get the value of the Primary Key field from the VBFlexGrid. I don't really like to use this way. It would be better to somehow synchronize rows in Recordset and rows in FlexGrid.

Perhaps the main difficulty is that the grid should be loaded dynamically, that is not at the moment when you reached the last record of the current "page".