--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 03:14 PM 3/08/2004 +0000, you wrote:
> >I try to create a simple view using isql:
> >
> >CREATE VIEW VW_CUSTOMERS
> >AS
> >
> > SELECT
> > "other_oid",
> > "name",
> > "remarks",
> > "code",
> > "VAT_No"
> > FROM
> > "t_others"
> > WHERE
> > "is_customer" = 1;
> >
> >and I get:
> >
> >statement failed, SQLCODE = -607
> >unsuccesfull metadata update
> >
> >
> >what do I do wrong?
>
> Try the query out in dsql to see what error caused the metadata

update to fail.

>
> /heLen

OK helen,

I declare myself a complete novice and as such I am not sure I can
follow you. I am using Delphi, so I tried to use a TIBSQL component
to execute the same statement. I got the same error as above, no more
details. I also tried EMS Interbase/Firebird Manager and got 'This
operation is not defined for system tables, unsuccessful metadata update.'

Any ideas?