Undo UniDBGrid Sorting

[Gabriel Fabrega]

Hello guys!

 

I have a UniDBGrid with some columns with the "Sortable" property enabled and the "OnColumnSort" event scheduled. Basically, I enter the field in the "IndexFieldName" property of TADQuery.

However, I need to clear this order ... Return to the original sort order, which is in the SQL query. Even closing and opening the query and clearing the property "IndexFieldName", prevails the ordering of the column that was clicked.

 

How to clear the ordering of the UniDBGrid columns?

 

Sorry for English. I'm brazilian.

 

Thank you!

[Sherzod]

Hi,

 

Which edition and build are you using?

[Gabriel Fabrega]

Hi Delphi Developer

 

1.0.0.1424

[Sherzod]

Hi,

 

Trial edition or ?

[Gabriel Fabrega]

I have an official license

[Sherzod]

First of all please visit here:

http://forums.unigui.com/index.php?/topic/6291-new-users-please-adjust-your-forum-email-address/

[Gabriel Fabrega]

Sorry. I already adjusted.

[Sherzod]

One possible solution maybe:

procedure TMainForm.UniButton1Click(Sender: TObject);
begin
  UniDBGrid1.JSInterface.JSCall('store.sorters.clear', []);
  //UniDBGrid1.JSInterface.JSCall('view.refresh', []);
  
  GridDataSet.Close;
  ...
  GridDataSet.Open;
end;

[Gabriel Fabrega]

Worked perfectly. Thank you!