The View name is V_T1 and your DROP VIEW is trying dropping a table T1.

[]'s

> ----- Mensagem original -----
> De: fabiano_bonin <fabiano@...>
> [SMTP:fabiano@...]
> Enviada em: sexta-feira, 20 de dezembro de 2002 14:40
> Para: ib-support@yahoogroups.com
> Assunto: [ib-support] Error on dropping view.
>
> Firebird-1.0.2 (Linux RedHat 7.2)
> Console (IBExpert 1.9.5.23)
> Component (TIB_Script - IBObjects)
>
> I'm trying to run this script in two places:
>
> IBExpert (Script Executive) and
> Delphi, with TIB_Script (IBObjects)
>
> IBExpert gives an error in the fourth statement:
> TIB_Script raises an exception in the fourth statement, too.
>
>
> create table t1 (
> a integer );
>
> insert into t1 (a) values (1);
>
> create view v_t1 as select a from t1;
>
> drop view t1;
>
> error: Dynamic SQL Error. SQL Error Code = -607. Log record header
> too small at offset 469399988 in log file 8Vt
>
> drop table t1;
>
> error: cannot delete Table t1. there are 1 dependencies.
>
>
> why is it happening?
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>