Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Little explain.. please (2000)

    Please explain me this 3 command when the rs is opened.Tks.

    rs.Open "TOTALE", cn, adOpenKeyset, adLockOptimistic, adCmdTableDirect

    adOpenKeyset
    adLockOptimistic
    adCmdTableDirect

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Little explain.. please (2000)

    You can look them up in the online help for the ADODB Open method.

    adOpenKeyset specifies what kind of recordset is opened:

    <table border=1><td>Constant</td><td>Description</td><td>adOpenDynamic</td><td>Records can be added, deleted and modified. You can see records added by other users while the recordset is open.</td><td>adOpenForwardOnly</td><td>You can only move forward (MoveNext), not backwards</td><td>adOpenKeyset</td><td>Records can be added, deleted and modified. You can not see records added by other users while the recordset is open.</td><td>adOpenStatic</td><td>Records can not be added, deleted or modified</td><td>adOpenUnspecified</td><td>Not specified</td></table>
    adLockOptimistic specifies how records are being locked while you are working with them:

    <table border=1><td>Constant</td><td>Description</td><td>adLockBatchOptimistic</td><td>As adLockOptimistic, but for batch updates</td><td>adLockOptimistic</td><td>Records are only locked when you call Update</td><td>adLockPessimistic</td><td>Records are locked when you start to modify them.</td><td>adLockReadOnly</td><td>Records can not be modified</td><td>adLockUnspecified</td><td>Not specified</td></table>
    adCmdTableDirect specifies what the "TOTALE" argument means (in this example, a table):

    <table border=1><td>Constant</td><td>Description</td><td>adCmdUnspecified</td><td>Not specified.</td><td>adCmdText</td><td>A SQL statement</td><td>adCmdTable</td><td>A table or query</td><td>adCmdStoredProc</td><td>A stored procedure (SQL Server)</td><td>adCmdUnknown</td><td>Unknown</td><td>adCmdFile</td><td>A stored recordset (SQL Server)</td><td>adCmdTableDirect</td><td>A table</td></table>

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Little explain.. please (2000)

    only, tks.

Posting Permissions

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