title: Sorting a table physically in Delphi
body: <p>Delphi does not seem to like multi-field indexes. </p>
  
  <p>How do I physically sort a a table so that I wind up with a table that has the rows in the desired order?</p>
  
  <p>Example:</p>
  
  <p>mytable.dbf</p>
  
  <pre><code>Field   Field-Name   Field-Type   Size
    0     Payer        Character     35
    1     Payee        Character     35
    2     PayDate      Date
    3     Amount       Currency
  </code></pre>
  
  <p>I need to produce a table sorted alphabetically by "Payee"+"Payer"</p>
  
  <p>When I tried using an index of "Payee+Payer", I got an error:</p>
  
  <blockquote>
    <p>"Field Index out of range"</p>
  </blockquote>