CxGrid and FetchRows problem

[rrcanalista]

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

[AlexP]

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;

[rrcanalista]

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

[AlexP]

hello,

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

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

[rrcanalista]

Thanks a lot. Reply very fast and efficient.

[AlexP]

hello,

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