From: rem_no_s.ppam.marco.foglia@tucsoft.com   
      
   pdx7.0.5.57 (compatibility NT4 SP5), bde 5.2.0.2, wXP.   
   This code ran for some years (maybe with w2000):   
   ...   
   if not sq.executeSQL(db,":priv:~contratto.db") then   
   	errorshow()   
   endif   
      
   sq=sql   
      
   /*   
   ALIAS: priv   
   */   
      
   alter table "~contratto" add ttax NUMERIC(10,2)   
      
   endsql   
   if not sq.executeSQL(db) then   
   	errorshow()   
   endif   
      
   ----------------------------------------------   
   now ran once and then gave "An error was trig...table does not exist"   
   (but it does exists). Changing the query to   
   alter table ":priv:~contratto" add ttax NUMERIC(10,2)   
   it comes:"..alias is not currently open".   
   If create a new query (not embedded in opal)"alter table "~contratto"   
   add ttax NUMERIC(10,2)" it runs fine.   
      
   thank you for your suggestions   
      
   marco   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)