title: Tdbf/tdataset sorting multiple fields in delphi
body: <p>I have a delphi application that uses tdbf which is based on tdataset with the advantage of not requiring bde engine.  I needed the table to be sorted and I did this one a single field by adding an indexdef and then specifying the indexfieldnames.</p>
  
  <p>I am trying to now get it to sort on 2 fields ie group men together and then women together and then have each group sorted on salary so that we see females from lowest earner to highest earner followed by men in the same way.</p>
  
  <p>I have read every piece of material stating that you simply specify sortfield of the indexdef as 'gender+salary'.  When I try use the index I get told that '+' is not a valid fieldname.  I have tried every delimeter from '.'. ','. '&amp;' and ';'.  Every delimeter gets picked up as a field that doesn't exist.  What is the correct way to sort a table on multiple fields?</p>
  
  <p>Thanks in advance
  Clinton Brits</p>