Mike,

Thanks for reading our book so closely!

The VFP certification exams test application of concepts, not buzz phrases. Consequently, if you understand the concepts being presented you can successfully apply your knowledge to the exam questions.

That being said, perhaps the wording should be improved/corrected.

Here's Ed Leafe's discussion from the "VFP3b View question" thread on ProFox beginning 1999/10/13. ( http://leafe.com/archiveSearch.html )

Ed Leafe:
VFP locks the view definition record in the DBC when the view is being opened and when it is being requeried. If many users are all running the same view from the same DBC, the views themselves are local and exclusive, but if the DBC is shared, you may get "record is in use" messages when the view is updated or requeried. It became so bad in an app I was involved with that we had to break the view information into a separate DBC, which was then automatically loaded onto the workstation when the app was run.

Ed Leafe:
The [1709 Database object is being used by someone else] error is the result of either a) someone accessing the view definition (USE or REQUERY), or b) someone modifying the view. Since views are never modified in production, I know that the error is just one of those cases of two people trying to access the same view at the same time...

Ed Leafe:
Dunno about [there being a KB article} but I have confirmed this with Doug Hennig, who knows more about the DBC than anyone in Redmond < g >.


>Hi Mark
>
>I didn't think Certfox was correct about "until the results are returned, no one else can requery their view"
>
>However, if this phrase is part of the MS Certification exam, I'll get the answer wrong ;) and be happy about it.
>
>Thanks