11 replies to this topic

[Marc]

Hi,

I have a Table filtered by a Filter method.

A combo box on the form to modify the filter.

Which method to use to refresh correctly the NextDBGrid (mono selection and not buffered records) ?

After modification of the filter, NextDBGrid has a strange comportement if selected record (before modify the filter) is not the first record and in a next page (scroll). I think that there is a desynchronization between TTable and NextDBGrid at this moment

Use of Refresh method of the NextDBGrid don't fix this issue.

Thanks!

[Boki (Berg)]

Hello Marc,

Can you please send me one small demo to I test it please. It will help a lot.

Best regards

[Marc]

Hello Marc,

Can you please send me one small demo to I test it please. It will help a lot.

Best regards

Simply, add a button in the Demo2 of NextDBGrid component with this code :

Table1.Filter := 'Salary > 20000';
Table1.Filtered := True;
Table1.Refresh;

Run the demo. Activate the Table. Move down the grid with keyboard or mouse.

Click on the Filter button.

If you use page up/page dn or wheel mouse, you can see that lines painted are updated by another data when selection is modify.

Other bug, when you use up keyboard, the scrolling paint the same first line on all lines of the grid is painted when you reach top of the table. Probably because internal record count of dbgrid isn't updated with the filter applyed...

[Boki (Berg)]

Hello Marc,

Thank you, this is unfortunately same bug from:
http://www.bergsoft....?showtopic=1653

As I say there, current solution is to disable MultiSelect (goMultiSelect in Options), or enable buffered mode (doBufferRecords in DataAwareOptions).

I am intensively working on it and I hope that it will be finished in next several days. I am sorry again.

Best regards

[Marc]

Hello Marc,

Thank you, this is unfortunately same bug from:
http://www.bergsoft....?showtopic=1653

As I say there, current solution is to disable MultiSelect (goMultiSelect in Options), or enable buffered mode (doBufferRecords in DataAwareOptions).

I am intensively working on it and I hope that it will be finished in next several days. I am sorry again.

Best regards

I have updated my post. My grid has a multiselect option to false

[Marc]

Other bug, when you use up keyboard, the scrolling paint the same first line on all lines of the grid is painted when you reach top of the table. Probably because internal record count of dbgrid isn't updated with the filter applyed...

+ use a big scroll with wheel mouse, display will be entirely corrupted... Already fixed in a previous release but re-appear in 4.1.5

[Boki (Berg)]

Hello Marc,

I have spot it too I will work on it. It seems that VertScrollBar is not updated when Filter is applied.

I have try now with adding:

CODE

NextDBGrid1.VertScrollBar.First;

After applying fiter and it work at first check, but I will continue to work on it.

Best regards

[Aurelio - Brazil]

Hello Marc,
To resolve your problem, do it:

CODE

//Disconnect the grid
NextDBGrid1.DataSource := nil;

//Filter table
DataSet.Filter := 'any filter';
DataSet.Filtered := true;
DataSet.Refresh;

//Reconnect the grid
NextDBGrid1.DataSource := DataSource1;

This works for me.

Aurélio - Brazil

[Marc]

Hello Marc,
To resolve your problem, do it:

CODE

//Disconnect the grid
NextDBGrid1.DataSource := nil;

//Filter table
DataSet.Filter := 'any filter';
DataSet.Filtered := true;
DataSet.Refresh;

//Reconnect the grid
NextDBGrid1.DataSource := DataSource1;

This works for me.

Aurélio - Brazil

Ohhh, yes, great ! This works for me too ! Many thanks !

Marc

[Marc]

This bug isn't fixed SINCE 9TH SEPT.... and this workaround don't work with last release

SORRY, I THINK THAT I WILL SEARCH ANOTHER DBGRID. I CANNOT WAIT MORE LONGER AN HYPOTHETIC FIX !!!!!!!!!!!!

[Boki (Berg)]

Hello Marc,

I didn't change anything for it in latest release. I don't know how this may be.

I am doing my best to solve every bug. It is not possible to solve them all in short time, specially such tricky bug as this one. Sometime it all looks like pushing a cat into a bag...

If you may, please use previous version until I see where is a problem.

Regards

[stefanw]

Hello Boki,

It seems I have the same problem with nextdbgrid version 5.4.2.
After filtering. the gridlines from the last records appear as empty rows (I set goGrid and ActiveRows). When I scroll in the dataset also outside the nextdbgrid, the filtered rows where mixed or disappear or appear at another row in the nextdbgrid. Some rows are empty or some data appears mutliple in the nextdbgrid.
The same behaviour as describe in this topics above.

Your workarounds are not function.

Do you have any tipps to workaround or setting some properties?

best regards
Stefan