|
Home > Archive > MS SQL Server Tools > April 2005 > result in view only after refresh
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
result in view only after refresh
|
|
|
| In Access this simple query works ok
changing the value in Client.idFam changes the value in Fams.FamStts with
out any action
SELECT Client.idStatus, FamilyStts.Stts
FROM Client INNER JOIN FamilyStts ON Client.idStatus= FamilyStts.idStatus;
but in SQL Server same result in the outer table happen only after
refreshing the view
what is wrong?
sam
| |
| Jacco Schalkwijk 2005-04-20, 9:23 am |
| Your question refers to tables and columns that are not in the query you
provided. Please clarify.
--
Jacco Schalkwijk
SQL Server MVP
"Sam" <focus10@zahav.net.il> wrote in message
news:uYXfpoDRFHA.2384@tk2msftngp13.phx.gbl...
> In Access this simple query works ok
> changing the value in Client.idFam changes the value in Fams.FamStts with
> out any action
>
> SELECT Client.idStatus, FamilyStts.Stts
> FROM Client INNER JOIN FamilyStts ON Client.idStatus= FamilyStts.idStatus;
>
> but in SQL Server same result in the outer table happen only after
> refreshing the view
>
> what is wrong?
> sam
>
>
| |
|
|
in table FamilyStts:
idStatus =1, Stts=Married
idStatus =2, Stts=NotMarried
view=
SELECT Client.idStatus, FamilyStts.Stts
when the view is running and i write's 1 in Client.idStatus, result in
FamilyStts.Stts must show immidiatly Married
but result shows up only after running the view again
why can't i see the change to Married or NotMarried as i write 1 or 2 in
Client.idStatus
with out any extra action?
sam
"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote
in message news:Op0K4KbRFHA.3824@TK2MSFTNGP10.phx.gbl...[color=darkred]
> Your question refers to tables and columns that are not in the query you
> provided. Please clarify.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
>
> "Sam" <focus10@zahav.net.il> wrote in message
> news:uYXfpoDRFHA.2384@tk2msftngp13.phx.gbl...
>
>
| |
| Hugo Kornelis 2005-04-22, 8:23 pm |
| On Fri, 22 Apr 2005 13:22:54 +0200, Sam wrote:
>
>in table FamilyStts:
>idStatus =1, Stts=Married
>idStatus =2, Stts=NotMarried
>
>view=
>SELECT Client.idStatus, FamilyStts.Stts
>
>when the view is running and i write's 1 in Client.idStatus, result in
>FamilyStts.Stts must show immidiatly Married
>but result shows up only after running the view again
>why can't i see the change to Married or NotMarried as i write 1 or 2 in
>Client.idStatus
>with out any extra action?
Hi Sam,
I'm not aware of any SQL Server tools that will automatically refresh a
view for you.
When you run a query, the query is sent from the client software to the
server; the server executes the query, then sends the output back to the
client. The client will then format and display the data, and most
clients will also store it, to allow you to scroll thorugh the output
withing having to execute the query again.
The architecture of SQL Server does not provide any mechanism or tool to
inform the client that some of the data displayed might be changed. So
the only way to make a view automatically refresh is to re-execute the
same query every second or so. Of course, that would have a drastic
impact on the overall performance of the server. (And besides, if I run
a stored procedure that modifies data and returns output, I would not
even WANT any client to re-execute it without my permission)!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
|
|
|
|
|