From: ctech@corel.ca   
      
   marco   
      
   This code works for me. P11 build 410. BDE 5.2   
      
   var   
   db database   
   sqlhandle sql   
   endvar   
      
   db.open(":PRIV:")   
      
   sqlHandle=Sql   
      
   alter table "~contratto" add ttax NUMERIC(10,2)   
      
   Endsql   
      
   try   
    sqlHandle.executesql(db)   
   onfail   
      errorshow()   
   endtry   
      
   db.close()   
      
   --   
   Bertil Isberg - CTECH   
   Paradox buglist:   
   online:       http://hem.bredband.net/bertilisberg/   
      
   "marco"  skrev i meddelandet   
   news:46164f69$1_1@news.bluewin.ch...   
   >   
   >> If create a new query (not embedded in opal)"alter table "~contratto"   
   >> add ttax NUMERIC(10,2)" it runs fine.   
   >>   
   >>   
   >> Which databse is selected in the alias control when you run this? WORK or   
   >> PRIV?   
   >   
   > PRIV (from the menu SQL/select alias...)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)