Results 1 to 2 of 2

Thread: Use of adOpenDynamic,adLockOptimistic

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2006
    Posts
    2

    Use of adOpenDynamic,adLockOptimistic

    HI Everyone... Can someone help me, what is the essence or the use of

    adOpenDynamic
    adOpenForwardOnly
    adOpenKeyset
    adOpenStatic

    adLockBatchOptimistic
    adLockOptimistic
    adLockPessimistic
    adLockReadOnly

    For Ex.
    Set rs3 = New ADODB.Recordset
    rs3.Open "Select * from tEmployee", cn, adOpenDynamic, adLockOptimistic

    I Frequently used the adOpenDynamic, adLockOptimistic in my SQL statement, but I just want to know the Distinction, I tried to search in Google but unfortunately I didnt found an answer.....

    by the way im now in my six months in using Visual basic 6.0.
    Hope u can help me..
    Thank you ver much

    andrew_vb

  2. #2
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,929

    Re: Use of adOpenDynamic,adLockOptimistic

    Moved from FAQ forum

    The answer can be found in the Help files, simply type any of them into VB, then click on them and press F1.

    In a nutshell:

    The Open options basically specify whether you want to be able to "move around" the recordset or not (eg: rs.MovePrevious) rather than just forwards, and whether updates from other users are shown (after a .Requery).

    The Lock options basically specify if changes can be made to the data, and how to deal with edits by other users for the same data.


    It is a good idea to use the right options for your situation (use the Help to find out which), as it not only makes things faster, but also reduces the chances for issues with other users who are using the same database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width