Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Sorry I must be appearing very thick let me give an example.
No, not at all. See some of my not-so-distant posts here if you want to see thick!
>user 1 adds to the field Title - "The Flintstones"
>user 2 adds to the field Forename - "Fred"
>
>They can both save their changes at the same time using optimistic buffering and both sets of changes get logged. However
>
>user 1 is seeing nothing against Forename
>user 2 is seeing nothing against Title
>
>as the view only seems to write changes not read any changes made to the base table.
>
>Is this right?
Yes. Not until the data is requeried from the base table into their view. A view is simply a cursor that exists in memory on each users PC. The only way it can show changes to the base table is if a Requery (or the equivalent) on the view is done which essentially repopulates the view.
Renoir
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only