title: How do I sort a CSV file in a TTable?
body: <p>I have a TTable, and I am loading CSV files to this TTable. Three fields are there: Id, Hits &amp; Path.
  I made some lookup fields to this TTable with another query.</p>
  
  <p>I want to sort the table. I am getting the message "Capability not supported." when I try to call <code>AddIndex('ndxHits','HITS',[]);</code></p>
  
  <p>Here is my code:</p>
  
  <pre><code>with DM.TblCVResults do
  begin
    try
      Active     :=  False;
      TableName  :=  'C:\CSV\123.txt';
      Active     :=  True;
  
      AddIndex('ndxHits','HITS',[]);
      AddIndex('ndxCandidate','LkCandidate',[]);
      AddIndex('ndxLastCV','LkLastCV',[]);
      AddIndex('ndxPostCode','LkPostCode',[]);
      IndexDefs.Update;
      Active     :=  True;
      DM.TblCVResults.IndexName := 'ndxHits';
    except
      on E: Exception do
        MsgError(E.Message);
    end;
  end
  </code></pre>