From: harrisjr@bwsc.org   
      
   I have tried sorting in OPEN, CAN DEPART, CAN ARRIVE, INIT - no luck. But   
   if I place the code in OPEN or INIT and open the form again the data is sorted.   
      
      
   I think I have to sort to a diffrent table   
      
      
   "Fred Z"  wrote:   
   >   
   >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   
   >   
   >Try testing the attach with if not cashTbl.attach("CashFlow.DB") then   
   >msginfo("I","oops") endif. "This method fails if the value of tableName   
   >is not valid (for example: the table name doesn't match the table type,   
   >or conflicts with the database name)."   
   >   
   >Also, your Arrive built in method placement for the code may conflict   
   >with the tableframe built in Open method. Open may have opened your   
   >tableframe and the table got locked somehow.   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)