Post reply

Updatable Views

  • July 28, 2010 at 4:26 pm

    #221820

    Hi

    I have created a view from a Table in database, but I keep adding new data into the Table. So my question is - How can I update a view to reflect the changes made in the Table?

    Thanks

  • July 29, 2010 at 3:49 am

    #1199674

    Do you mean you've added new columns to the table definition or just inserted new rows into the table?

    If you've just added new rows then you need do nothing. However if you've added new columns to the table definition then you will need to add the new columns to the SELECT statement in your view definition.

    Nigel
    How to post questions

  • July 29, 2010 at 4:15 am

    #1199682

    The view contains Just SQL select statement only...

    Cheers!

    Sasi

  • July 29, 2010 at 11:22 am

    #1199957

    Hi

    I just add new rows to the table.

    Thyanks

  • July 29, 2010 at 1:55 pm

    #1200037

    Novicejatt (7/29/2010)

    Hi

    I just add new rows to the table.

    Thyanks

    You don't need to update the view unless you have added new columns to your table, which you want to display using the View... View is nothing but a virtual table

  • July 29, 2010 at 2:16 pm

    #1200045

    Thank you very much.

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

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