Solved

Cursor type Static  Is changes visible?  to whom?

Posted on 2000-04-15
4
196 Views
Last Modified: 2010-05-18
Need some help
I came across a  contradictory statement in a book: (EXAM CRAM ) VISUAL BASIC DISTRIBUTED
(I might be wrong here)

Question: ADO cursor Locations
Static  --> adOpenStatic : User's changes will not be able to be seen and it is updateable.
 
In the following page it says in case of Static,  Changes is "Visible".
 
From your experience, please let me know which is correct here.
 
Thanks
0
Comment
Question by:PERORA
  • 2
4 Comments
 
LVL 9

Expert Comment

by:Ruchi
ID: 2719170
Not from my experience, but ...
from the MSDN Library, it says "Static cursor. A static copy of a set of records that you can use to find data or generate reports. Additions, changes, or deletions by other users are not visible."
0
 
LVL 9

Expert Comment

by:Ruchi
ID: 2719180
Not from my experience, but ...
from the MSDN Library, it says "Static cursor. A static copy of a set of records that you can use to find data or generate reports. Additions, changes, or deletions by other users are not visible."

In other words, ... cannot see other's changes.
0
 
LVL 14

Accepted Solution

by:
wsh2 earned 50 total points
ID: 2719294
Rephrasing Ruchi's comment:
You can see YOUR Changes to the database.. but no one else's.

Good luck with 70-175.. <smile>.
0
 

Author Comment

by:PERORA
ID: 2721522
Thanks to all
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now