Procedure TfrmHR_Operate. OrderUniDesc;
The begin
OldSQLText:=UniQuery1. SQL. The Text;
UniQuery1. Close;
UniQuery1. SQL. The Clear;
UniQuery1. SQL. Text:=OldSQLText + 'order by' + DBGridEh1. Columns [5]. The FieldName + 'DESC';
//the SQL statements here is normal
UniQuery1. Open;

UniQuery1. SQL. Text:=OldSQLText;//here after assignment, dbgirdeh display, cancel this words of normal

DBGridEh1. SetFocus;
end;



Delphi xe
Unidac connection MYSQL

CodePudding user response:

After the assignment, in the open again!
UniQuery1. SQL. Text:=OldSqlText;
UniQuery1. Open;
DBGridEh1. SetFocus;

CodePudding user response:

Problem is I want is my first time to open as a result, the assignment again after don't want to open the

In addition, the way I wanted to solve UniDac + dbGirdEh, click on the title bar to sort with the

Could I have other ways to solve the problem of sorting?

CodePudding user response:

To open the display content is different

I want to do now is a function: click on the title bar dbgirdeh can automatic sorting data, have what good way?

Unidac + dbgirdeh don't know how to implement, Internet use ADO example is the sort of way, but Unidac not sort method

CodePudding user response:

Why no one can do

CodePudding user response:

Dbgirdeh bring click on the title bar of the automatic sorting data

CodePudding user response:

Look for options that you can sort of,