Re: Error 457, why?

Richard Spitz (spitz@GANS2X.ana.med.uni-muenchen.de) wrote: : create synonym syn_errtable for personal@DBPERS:"personal".errtable; : create view v_errtable as select field1 f1, field2 f2 from syn_errtable; : create table new_errtable (feld1 smallint, feld2 char(30)); : insert into new_errtable select * from v_errtable; : The last statement bombs with error -457! I've seen this but I don't know if it's a reported bug. If you create new_errtable and perform some other statement(s) before you do the insert does it still happen? I did a create/insert like that that failed every time until I put all of the create statments at the top of the file. Wierd but it worked. -- gburnore@garys.arasmith.com ------------------------------------------------------------------------------- How you look depends on where you go. -------------------------------------------------------------------------------