> >I have read that I should use "snapshot".
> >
> >If using snapshot is the correct choice (for possible queries that my
> >sit on a users display for hours),
>
>Snapshot is no better for queries that sit on a user's display for
>hours. That kind of query should be a read-only query in read committed
>isolation.

What I do (and I am NOT saying it is the "right" way to do this) in this
situation is to read the values from a query into variables, close the
query (and commit the transaction) and display those on the screen for the
user.

What this would do is to "cut" the dependency on a query being open more
than is absolutely necessary.

Regards

Tim


[Non-text portions of this message have been removed]