Devart Forums

Hi, is there any problem with FetchRows property and cxGrid?

When I link to a cxGrid, the count of records returned are not the same of FetchRows property. I'm using TUniQuery.

If I use standard DbGrid the property FetchRows works fine!

In this table, there is about 4000 records, I'd like to retrieve only 25/30 records!

Thanks

Hello,

By default, TCxGrid reads out all records from the table independently on our FetchAll option, to change this behaviour, you should set the GridMode property to True


cxGrid1DBTableView1.DataController.DataModeController.GridMode := True;

Hi, thanks, it worked partially, When a Set Fetch to 10, the record count is 70. Example

FetchRows Records Count
10 70
20 80


but this tip was helpful, thanks

hello,

Try setting the GridModeBufferCount property to the value that you have set for our FetchRows property

cxGrid1DBTableView1.DataController.DataModeController.GridModeBufferCount := UniQuery.FetchRows;

Thanks a lot. Reply very fast and efficient.

hello,

If you have any other questions, feel free to contact us.