How to dbgrid columsort in runtime?

[Freeman35]

Hello,

How can I set unidbgrid's column(s) sort on form create?

Or I need just set column's order direction glyph? (up or down) 'cos my query has a default "order by" structure, I have to set this to grid, so user can see which column(s) sorted when form opened.

regards.

[Sherzod]

Hello,

This post may help you:

 

[Freeman35]

Thank you its worked. But

If Grid's LoadMask.WaitData is True, (Target is owner form) never unlock.

[Freeman35]

function reconfigure(sender, store, columns, oldStore, oldColumns, eOpts)
{
    if (columns[0].isSortable()) {
        columns[0].sort('ASC')
    }
}

This code, remove trigger event.

I have TUniDBText and TUniDBEdit. this components's datasource is same with TUniDBGrid. If Add reconfigure code to grid, this component not triggered, I mean when move grid row, (grid's row change) thşs component's values not change, dbedit's onchange events not triggered too.

What can be wrong?

[Sherzod]

6 hours ago, Freeman35 said:

This code, remove trigger event.

I have TUniDBText and TUniDBEdit. this components's datasource is same with TUniDBGrid. If Add reconfigure code to grid, this component not triggered, I mean when move grid row, (grid's row change) thşs component's values not change, dbedit's onchange events not triggered too.

What can be wrong?

It seems I couldn't reproduce your issue.

Can you explain in more details (or by making a simple testcase) ?!

[Freeman35]

I added video, when run in my system. original demo from  this link. I added just two component and reconfigure function thats all.

unigui ver. 1480,  win10-x64, tokyo.

regards.

0 FreeMan.7z

[Sherzod]

On 1/13/2019 at 9:38 PM, Freeman35 said:

I added just two component and reconfigure function thats all.

Hello,

One possible solution:

procedure TMainForm.UniFormReady(Sender: TObject);
begin
  UniDBGrid1.JSInterface.JSCall('getSelectionModel().resumeEvents', []);
end;

 

[Freeman35]

Thank you so much.

Another perfect solution. I tested and its work. as expected

Best regards.