From: n_sp_hum_marco.foglia@tucsoft.com   
      
   Bertil Isberg wrote:   
      
   >   
   > 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   
    >...   
      
   For me too, with pdx7 + bde 5.2 (and WXP). The other code, with alias   
   defined inside "sql endsql", continues to work with pdx,w2000, bde 5.1.   
   This code works with bde 5.2 and 5.1:   
   db.open("another_alias")   
   sq=sql   
   	select * from ":priv:~contratto"   
   endsql   
   sq.executeSQL(db,":priv:bof.db")   
      
   My conclusion would be that BDE 5.1 handle alias differently than 5.2   
   for DDL (Data Definition Language). BDE 5.1 does not care at all what DB   
   is open (for DB tables). BDE 5.2 care only for DDL and does not want   
   alias inside sq endsql.   
      
   thank you   
      
   marco   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)