From: info@sundialservices.com   
      
   Jeanette wrote:   
   > The have a table - CashFlow that has setGenFilter on ContractNo.   
   > I have a form with a table frame of CashFlow that has a formula using the   
   > StreetCode column on a form.   
   > I added another column named StreetSort that has the same data as   
   > StreetCode - however the code below does not sort the table   
   >   
   > Why???   
   >   
   > cashTbl.attach("CashFlow.DB")   
   >   sort cashTbl   
   >   on "ContractNo", "StreetSort"   
   > endSort   
      
   You can't sort on a calculated field in Paradox.  You can write logic that   
   will do the calculation and store the calculated result in a permanent   
   field, then sort on that.   
      
   There are various important restrictions on "sort," for example dealing with   
   keyed vs. non-keyed tables.  Some tables can be sorted into themselves;   
   others cannot.   
      
   ----   
   ChimneySweep(R): Fast(!) table repair at a click of the mouse!   
   http://www.sundialservices.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)