or ... "commit;" before you execute the ddl.

bill

ibrahim Bulut wrote:

> There isn't any wrong sql statement.
> I have seen this problem some times.
>
> Backup the database with gbak or Ibcolsole.
> Restore the database.
> After that execute sql statement.
> It will success probably.
>
> Ibrahim Bulut
> Software Developer
> Republic of Turkey
> ----- Original Message -----
> From: "Benny Setiawan Tanua" <btanua@...>
> To: <ib-support@yahoogroups.com>
> Sent: Thursday, May 23, 2002 9:14 AM
> Subject: [ib-support] unsucessful metadata
>
> > Dear All,
> >
> > i have problem
> > i use this query :
> > CREATE TABLE M_ROLES(ROLE_ID INTEGER NOT NULL PRIMARY KEY,
> > STATUS INTEGER,
> > NAME VARCHAR(64),
> > CREATED DATE,
> > CLOSED DATE,
> > NOTE VARCHAR(128),
> > PARENT_ROLE_ID INTEGER ,
> > FOREIGN KEY (PARENT_ROLE_ID) REFERENCES
> > M_ROLES(ROLE_ID)
> > );
> >
> > but error :
> > unsucessful metadata object M_ROLES is in use
> >
> > does anyone knows about this error and why..??
> >
> > Thanks,
> > -bst-
> >
> >
> > 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/
> >
> >
> >
>
>
> 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/