Re: Can you update more then one table through the view?

If a view is based on a SINGLE underlying table, you can insert, update or delete rows in a view. This will actually insert, update, or delete rows in the underlying table. There are some restrictions however...

You cannot insert if the underlying table has any NOT NULL columns that don't appear in the view.

You cannot insert or update if any one of the views columns referenced in the insert or update contains functions or calculations.

You cannot insert, update or delete if the view contains group by, distinct, or a reference to the pseudo column "rownum".

Hope this helps more than the previous reply... Received on Fri Feb 27 1998 - 00:00:00 CST