probleme de comprehension

Question

Set req = New Recordset 'déclaration d'un nouveau recordset
             req.Open "SELECT * FROM Identification WHERE  Id = '" & Combo1.Text & "'", conn, adOpenDynamic, adLockOptimistic
            If (req.EOF) Then
               MsgBox " Cet utilisateur n'existe pas", vbInformation, "Information"
                Combo1.SetFocus

Bonjour voila j'ai souligné les termes que je ne comprend pas, serait il possible que quelqu'un me decrit leur utilisation???
car je galere pour comprendre en plus mon aide ne marche plus depuis quelque jour c bizarre ...

cs_Exploreur · Answer

Salut,

Voici un petit tuto sur le recodset, cela devrait t'éclairer un peu...

A+
Exploreur

jrivet · Answer

Salut,
Texte tiré de la MSDN: (dispo sur internet aussi)

* CursorType : This optional parameter specifies a CursorTypeEnum value that
determines the type of cursor that the provider should use when opening the
Recordset. See the CursorType property of a Recordset object for more
information.
This parameter can be one of the following enumerated values for
CursorTypeEnum:

Enumeration |Value |Description |----
adOpenUnspecified, -1, Indicates an unspecified value for the CursorType (not
supported by the OLE DB Provider for AS/400 and VSAM)., ----
adOpenForwardOnly, 0, Specifying this value opens a forward-only-type cursor. Under
the OLE DB Provider for AS/400 and VSAM this cursortype is mapped to adOpenDynamic., ----
adOpenKeyset, 1, Specifying this value opens a keyset-type cursor (not supported
by the OLE DB Provider for AS/400 and VSAM)., ----
adOpenDynamic, 2, Specifying this value opens a dynamic-type cursor, the only
CursorType supported by the OLE DB Provider for AS/400 and VSAM.
Additions, changes, and deletions by other users are visible, and all types of
movement through the recordset are allowed, except for bookmarks if the provider
does not support them., ----
adOpenStatic, 3, Specifying this value opens a static-type cursor (not supported
by the OLE DB Provider for AS/400 and VSAM).

This optional argument defaults to adOpenForwardOnly, a value that is
mapped to adOpendDynamic by the OLE DB provider for AS/400 and VSAM.

<hr size= "2" width="100%" />
*  LockType :  This optional parameter specifies a LockTypeEnum value that
determines what type of locking (concurrency) the provider should use when
opening the recordset. See the LockType property of a Recordset object
for more information.
This parameter can be one of the following enumerated values for
LockTypeEnum:

Enumeration |Value |Description |----
adLockUnspecified, -1, Indicates an unspecified value for the LockType (not
supported by the OLE DB Provider for AS/400 and VSAM)., ----
adLockReadOnly, 1, Specifying this value opens a Recordset object read-only and
data cannot be altered., ----
adLockPessimistic, 2, Specifying this value opens a recordset with pessimistic
locking. Record-by-record, the OLE DB Provider does whatever is necessary to
ensure successful editing of the records, usually by locking records at the data
source immediately upon editing., ----
adLockOptimistic, 3, Specifying this value opens a recordset with optimistic locking.
Record-by-record, the OLE DB Provider locks records only when the Update
method is invoked on a Recordset object., ----
adLockBatchOptimistic, 4, Specifying this value opens a Recordset with batch optimistic
locking. This value is required for batch update mode as opposed to immediate
update.

This optional argument defaults to adLockReadOnly.

@+: =89254 Ju£i?n
Pensez: Réponse acceptée

jrivet · Answer

Re,
Ah le Ctrl C + V a fait une petite erreur. 
adOpenDynamic est inscrit en blanc (désolé)
@+: Ju£i?n
Pensez: Réponse acceptée

cs_Exploreur · Answer

Salut,

Eof et Bof marque la fin d'un fichier rencontré(eof) ou le début (bof).

A+
Exploreur

Probleme de comprehension

4 réponses

Votre réponse

Discussions similaires