Undo UniDBGrid Sorting

[Gabriel Fabrega 0]

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 1183]

Hi,

 

Which edition and build are you using?

[Gabriel Fabrega 0]

Hi Delphi Developer

 

1.0.0.1424

[Sherzod 1183]

Hi,

 

Trial edition or ?

[Gabriel Fabrega 0]

I have an official license

[Sherzod 1183]

First of all please visit here:

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

[Gabriel Fabrega 0]

Sorry. I already adjusted.

[Sherzod 1183]

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 0]

Worked perfectly. Thank you!