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