Post reply

View Error

  • September 6, 2005 at 8:23 am

    #111645

    Hi,

    I got almost all defined Mcrosoft Error Messages from a newly created UNION ALL VIEW and got out of all of them. But now it's showing up another Error Message like this:

    "Table_VW" is not updatable because the source query contains references to partition table "Table01'

    Any Ideas?

  • September 6, 2005 at 8:41 am

    #587808

    Are you using SQL 2000 or v7? and have you set up the constraints properly?

  • September 6, 2005 at 8:47 am

    #587811

    I am using SQL2000. All Check Constraints are correct. I have PK with 3 columns and the check constraint is the 3rd column. I have specified all the columns in the view for Insert. This view is a UNION ALL View.

    Jagan

  • September 6, 2005 at 9:47 am

    #587830

    Friends,

    I got out of this error by creating a INSTEAD OF INSERT TRIGGER.

    Thanks

  • September 6, 2005 at 9:55 am

    #587835

    Please post the whole code you are using :

    - Tables

    - Keys

    - Views

    - Triggers

    - Sample data

    - Expected results from the trigger

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply