Hi all, I have a TClientdataset with a lookup field and I would like a data grid, which linked to it, could be sorted by this lookup field. As I know, lookup type field cannot be sorted by TClientdataset by index. I am using GJL Software's TExRxDBGrid and I tried to use its sort function(sortorder and sortfieldnames) but it doesn't work. Any advice?? Thanks, Terence

 
利用 TClientdataSet的OnFilterRecord 事件    procedure TForm1.ClientDataSet1FilterRecord(DataSet: TDataSet;
  var Accept: Boolean);
begin
  If ..... THen 
    Accept := True
  Else
    Accept := False;
end;

_______________________________________ 深藍的魚，祝您好運..........連連

可參考改用 fkInternalCalc 類型的 TField

It works!!! (SORRY for the late reply) How do I close this topic??

Hi Mickey, It works by IntenalCalc field!!! (SORRY for the late reply) How do I answer (close this topic??