Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Arrow Unanswered: View doesnt seems to be refreshed automatically

    Whenever i make any row update in one of tables which include
    in my view (virtual table) : View doesnt seems to be refreshed automatically . Only by executing manually refresh command.
    How can i cause the view to be refreshed automatically by any
    change in each of the sub tables of the view?

    Tnx
    Last edited by symonnon; 10-23-03 at 12:59.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: View doesnt seems to be refreshed automatically

    Originally posted by symonnon
    Whenever i make any row update in one of tables which include
    in my view (virtual table) : View doesnt seems to be refreshed automatically . Only by executing manually refresh command.
    How can i cause the view to be refreshed automatically by any
    change in each of the sub tables of the view?

    Tnx
    A view...like in CREATE VIEW AS SELECT something?

    Since it's not physical...how can it not reflect the change?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    symonnon wants the changes to be reflected in the query immediately, without having to re-execute it.

    No can do.

    blindman

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by blindman
    symonnon wants the changes to be reflected in the query immediately, without having to re-execute it.

    No can do.

    blindman
    What like a populated control on a form?

    Everything is event driven, no?

    And you'll know when the update occurs...just re execute the requery the data...

    Or is that not it?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Oct 2003
    Posts
    2

    in another words

    Lets put it this way: my VIEW contains 2 tables :A , B.
    Whenever a row is updated (/ inserted) in a table B,
    then this change must be shown in my VIEW.
    I mean that my VIEW do NOT show a fresh data.
    Btw, all queries on table B activated by an asp page (active server page)

    I can force my VIEW to show a fresh data by refreshing it manually.

    I know that VIEW usually must show a fresh data ,whenever each of contained tables is changed.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You will have to refresh the view manually or through your interface code. Once the data leaves SQL Server it is beyond it's scope of control. It has no way of knowning all the users or all the interfaces that may still be using the data, so it can't issue data-updates to those interfaces.

    blindman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •